Excel Pivot Table - Expand total line

April 11, 2018 at 03:22:42
Specs: Windows 10 Home 64bit, Intel Core I5 16Gb RAM
I have a very simple pivot table which I have included a screen shot of in the link below

For each age group (16-18 and 19+) I summarise the number of leavers, completers and achievers for each level.

At the very bottom, the pivot table sums up the totals for both age groups. What I want to do is expand this total so that it reports totals for both age groups for each of the levels. In the past I have simply copied the pivot table and manually inserted a combined total at the bottom. It would be good if this was an inbuilt part of the pivot table ... but if there is a way to do this, I dont know what it is. Does anyone know if this is possible?

Thanks


See More: Excel Pivot Table - Expand total line

Report •

#1
April 11, 2018 at 03:24:31
doesnt look like my link got included in my original post. I'll try and paste it again here

https://www.dropbox.com/s/ueevsbi7r...


Report •
Related Solutions


Ask Question