Differences

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

--- transformations:subtotal [2021/05/05 10:47] – 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 |
@@ Line 73: / Line 73: @@
 | East   |  125 |   325 |
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//1769/1|How to do recursive loops in EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/qM6kmqrDRWiEDJFljIa2u6QWre1.morph|Project]]; Module: //Module 1//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
+  * [[https://community.easymorph.com/t//1837/4|Joining different pairs of value equivalences into “global equivalences”]] ([[https://community.easymorph.com/uploads/short-url/1TpBXIjf6r4auDHlOBejKh2rSTw.morph|Project]]; Module: //Group//; Group: //Tab 1//; Table: //Input//;\\ Action position: //2//)
+  * [[https://community.easymorph.com/t//2505/2|Check a column for unique and/or duplicate values and group by non-unique values]] ([[https://community.easymorph.com/uploads/short-url/7s9tWfHaseZ9EqSBdVmjSfGagIS.morph|Project]]; Module: //Main//; Group: //Group 1//;\\ Table: //Identify the number of accounts//; Action position: //4//)
 \\
 =====See also=====
   * [[transformations:aggregate|Aggregate]]