You can calculate cumulative totals such as moving aggregate or running aggregate.
Usie the Cumulative Value step in the data flow editor.
- Click Add a step (+), and select Cumulative Value.
- Use the options on the Cumulative
Value pane to configure your
Field Description Aggregate Select the data column to calculate. Function Select the cumulative function to apply. Rows You can edit this field only for specific functions. New column name Change the aggregate column name. (+) Aggregate Add an aggregate column. (+) Sort Column Specify how you'd like to sort each new cumulative column.