Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: can we get cumulative totals using any step....

  1. #1

    Default can we get cumulative totals using any step....

    hi
    is there any way we could get a cumulative/running total of records in a group....is there any step available for this..
    GROUP BY gives only the overall aggregation on a group..
    but if i want to get a cumulative total ...how to do that...

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Version 3.1 has running total and average in the "Group By" step.

  3. #3

    Default

    Was this moved / removed? I've checked group by and memmory group by, and I don't see 'running total' or 'running average'

    Thanks!

    -Eric

  4. #4

    Default

    I see now it's 'Cumulative sum'. I think the name could be clearer, but it works great :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.