ヒント
このツールには「ツールごとに学習」があります。 サンプルワークフローへのアクセス を参照して、 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.