Add Cumulative Values to a Data Flow

You can calculate cumulative totals such as moving aggregate or running aggregate.

Use the Cumulative Value step in the data flow editor.

1. Click Add a step (+), and select Cumulative Value.
2. Use the options on the Cumulative Value pane to configure your aggregate.

   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.