How To Calculate RUNNING_SUM in Tableau Prep

發佈時間 : 28 Jun 2021
上次修改日期 : 30 Oct 2023

問題

How To Calculate RUNNING_SUM in Tableau Prep

Source data:
User-added image

Output:

環境

Tableau Prep Builder

答案

1. Connect to source data [Sheet 1]

2. Add a Clean Step [Clean 1]

3. Join [Sheet 1] and [Clean 1] with clauses below:

[Clean 1].[Order Date] >= [Sheet 1].[Order Date]
[Clean 1].[Category] = [Sheet 1].[Category]

4. Rename [Sheet 1].[Sales] to [RUNNING_SUM(Sales)]

5. Add Aggregate [Aggregate 1] step as bellow:

Grouped Fields: [Clean 1].[Order Date] & [Clean 1].[Category]
Aggregated Fields: SUM ( [RUNNING_SUM(Sales)] )

6. Join [Aggregate 1] and [Clean 1] with clauses below:

[Clean 1].[Order Date] = [Aggregate1].[Order Date]
[Clean 1].[Category] = [Aggregate 1].[Category]

7. Remove the fields that are not needed in the Output.

Please refer to the attached sample flow file for details.
User-added image