transformations:subtotal
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | transformations:subtotal [2018/07/22 16:00] – created dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Total / subtotals ===== | ||
+ | This action appends to a dataset a new column that contains an aggregated total for selected column, or subtotals for groups. | ||
+ | |||
+ | **Example 1** | ||
+ | |||
+ | Source dataset: | ||
+ | ^ Region ^ Sales ^ | ||
+ | | North | 100 | | ||
+ | | East | ||
+ | | North | 150 | | ||
+ | | East | ||
+ | |||
+ | Objective: add a column with Total Sales. | ||
+ | |||
+ | Resulting dataset: | ||
+ | ^ Region ^ Sales ^ Total Sales ^ | ||
+ | | North | 100 | 575 | | ||
+ | | East | ||
+ | | North | 150 | 575 | | ||
+ | | East | ||
+ | |||
+ | **Example 2** | ||
+ | |||
+ | Source dataset: | ||
+ | ^ Region ^ Sales ^ | ||
+ | | North | 100 | | ||
+ | | East | ||
+ | | North | 150 | | ||
+ | | East | ||
+ | |||
+ | Objective: add a column with Total By Region. | ||
+ | |||
+ | Resulting dataset: | ||
+ | ^ Region ^ Sales ^ Total By Region ^ | ||
+ | | North | 100 | 250 | | ||
+ | | East | ||
+ | | North | 150 | 250 | | ||
+ | | East | ||
+ | |||
+ | **See also** | ||
+ | |||
+ | * [[transformations: |
transformations/subtotal.txt · Last modified: 2022/10/02 20:15 by craigt