Tipp
Für dieses Tool gibt es ein One-Tool-Beispiel. Unter Zugriff auf Beispiel-Workflows erfahren Sie, wie Sie dieses und viele weitere Beispiele direkt in Designer Cloud aufrufen können.
Use Running Total to calculate a cumulative sum per row in a dataset.
Row | Value | RunTot_Value |
|---|---|---|
A | 10 | 10 |
B | 12 | 22 |
C | 4 | 26 |
It can also create sums of groups of rows and calculate the cumulative sums of multiple columns at the row or group level.
Row | Group | VALUE_1 | RunTot_VALUE_1 | VALUE_2 | RunTot_VALUE_2 |
|---|---|---|---|---|---|
A1 | A | 10 | 10 | 7 | 7 |
A2 | A | 5 | 15 | 3 | 10 |
B1 | B | 12 | 12 | 5 | 5 |
B2 | B | 8 | 20 | 1 | 6 |
C1 | C | 4 | 4 | 11 | 11 |
C2 | C | 2 | 6 | 9 | 20 |
D1 | D | 6 | 6 | 0 | 0 |
Select the Columns to Compute Running Total. New columns are added with a RunTot_ prefix to show running totals for each column selected.
Select the Columns to Group By (Optional).
Select how to sort your columns in the Sort By table. The row position of incoming data isn't preserved. Sort by column to return an accurate range.