Dica
Esta ferramenta tem um fluxo de trabalho de exemplo. Visite Exemplos de fluxos de trabalho para saber como acessar esse e muitos outros exemplos diretamente no Designer Cloud.
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.