transformations:subtotal
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
transformations:subtotal [2021/07/18 00:02] – [Examples] craigt | transformations:subtotal [2021/07/18 00:03] – craigt | ||
---|---|---|---|
Line 23: | Line 23: | ||
The new column will appear as the rightmost column in the dataset, by default. | The new column will appear as the rightmost column in the dataset, by default. | ||
- | The grouping aspect of the //Subtotal inside groups// option is case sensitive. | + | The grouping aspect of the //Subtotal inside groups// option is case-sensitive. |
\\ | \\ | ||
Line 42: | Line 42: | ||
> Groups is " | > Groups is " | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^ Region ^ Sales ^ Total Sales ^ | ^ Region ^ Sales ^ Total Sales ^ | ||
| North | 100 | 575 | | | North | 100 | 575 | | ||
Line 66: | Line 66: | ||
> Groups is " | > Groups is " | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^ Region ^ Sales ^ Total By Region ^ | ^ Region ^ Sales ^ Total By Region ^ | ||
| North | 100 | 250 | | | North | 100 | 250 | |
transformations/subtotal.txt · Last modified: 2022/10/02 20:15 by craigt