Add Cumulative Values to a Data Flow

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

Usie 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.