When I add 2 groups under rows (for example, Group type (here is Group1 and Group2), plus another group (a,b,c,d), I would like to have the pivot include with the Group type the "totals" of subgroups a,b,c, &d, instead of just 1 row of grand totals.
Any suggestions?
a1 a2 a3 a4
GROUP 1
a 1 1 1 1
b 1 1 1 1
c 1 1 1 1
GROUP 2
a 2 2 2 2
b 2 2 2 2
c 2 2 2 2
d 2 2 2 2
TOTAL
a 3 3 3 3
b 3 3 3 3
c 3 3 3 3
d 2 2 2 2
Bookmarks