Hi,
This is a simplified version of my question, but the same principles apply.
I have an employee data set, and each employee belongs to 1 of 2 Departments
(say, A and B) and also 1 of 2 Regions (say, East and West). In the layout
section of the pivot table, I have Department as my first Row selection, and
Region as my second Row selection. And then my Data is the count of
employees. The Total only shows the Grand Total - is it possible for it to
show the sub-totals for each Region as well as the Grand Total?
Thanks.