User Tools

Site Tools


transformations:subtotal

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
transformations:subtotal [2021/05/05 10:47] craigttransformations: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.  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" > Groups is "Column total"
 \\  \\ 
-**Result:**+**Result table:**
 ^ Region ^ Sales ^ Total Sales ^ ^ Region ^ Sales ^ Total Sales ^
 | North  |  100 |   575 | | North  |  100 |   575 |
Line 66: Line 66:
 > Groups is "Subtotal inside groups" (column "Region" selected) > Groups is "Subtotal inside groups" (column "Region" selected)
 \\  \\ 
-**Result:**+**Result table:**
 ^ Region ^ Sales ^ Total By Region ^ ^ Region ^ Sales ^ Total By Region ^
 | North  |  100 |   250 | | North  |  100 |   250 |
Line 73: Line 73:
 | East    125 |   325 | | 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===== =====See also=====
   * [[transformations:aggregate|Aggregate]]   * [[transformations:aggregate|Aggregate]]
transformations/subtotal.txt · Last modified: 2022/10/02 20:15 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki