Differences

This shows you the differences between two versions of the page.

--- transformations:subtotal [2021/07/18 00:02] – [Examples] craigt
+++ transformations:subtotal [2022/10/02 20:15] (current) – update action category craigt
@@ Line 1: / Line 1: @@
 {{ transformations:SubtotalAction.png}}
 ====== TOTAL/SUBTOTALS ======
-Category: Transform / Math\\
+Category: Transform / Advanced\\
 \\
@@ Line 23: / Line 23: @@
 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.  Values in the grouping column(s) having different cases will be calculated as unique values (e.g. not combined).\\
+The grouping aspect of the //Subtotal inside groups// option is case-sensitive.  Values in the grouping column(s) having different cases will be calculated as unique values (e.g. not combined).\\
 \\
@@ Line 42: / Line 42: @@
 > Groups is "Column total"
 \\
-**Result:**
+**Result table:**
 ^ Region ^ Sales ^ Total Sales ^
 | North  |  100 |   575 |
@@ Line 66: / Line 66: @@
 > Groups is "Subtotal inside groups" (column "Region" selected)
 \\
-**Result:**
+**Result table:**
 ^ Region ^ Sales ^ Total By Region ^
 | North  |  100 |   250 |