Community
Participate
Working Groups
I would like to be able to add level subtotals at the bottom of a crosstab above the Grand total area, ie. Unit1 Group1 Group2 Unit1 total Unit2 Group1 Group2 Unit2 total Group1 total - ??? Group2 total - ??? Grand total
Is the "Group1 total" value calculated upon all "units"? In that case, it's just a grand total, you can just change the label or insert another data item to represent the total value in the original grand total row/cell.
Group 1 total is still a subtotal, as it counts only the items belonging to Group 1 in all units. So if I have 20 groups in each unit, I would like the 20 subtotals listed above the grand total, and then the grand total.