~savoy/ade#32: 
feature: data.subtotal() should also implement column subtotals

Row subtotals are more common than column subtotals

Prior

year                   2020          2021
month                     1      2      1      2
name         location
Foo          Loc1     58079  76576      0  83248
Foo          Loc2     18497  85454  15339  62458
Foo - Total  
Bar          Loc3     76626  28186  17778  32187
Bar          Loc1      8828  16128  17619  52834
Bar - Total 

Desired

year                   2020         2020 - Total  2021         2021 - Total
month                     1      2                   1      2
name         location
Foo          Loc1     58079  76576                   0  83248
Foo          Loc2     18497  85454               15339  62458
Foo - Total  
Bar          Loc3     76626  28186               17778  32187
Bar          Loc1      8828  16128               17619  52834
Bar - Total 
Status
REPORTED
Submitter
~savoy
Assigned to
Submitted
9 months ago
Updated
9 months ago
Labels
feature

~savoy 9 months ago

This should also be auto-generated when a pivot table is created with multiple columns i.e. year & month -> column subtotal vs year -> no column subtotal.

Register here or Log in to comment, or comment via email.