I have created a pivot table, using 3 column levels and 1 row level to report floor area for each institute in my university, split into 3 categories. Please see attached file with an example.
Is there a way to add the "Area type"-level to the subtotal of the faculties and the grand total, so that I can see a break down of the total faculty and university area into the three categories?
Bookmarks