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