grouping subtotals

[grifter]

Hi

using Excel 2007

I have a pivot table and I want to have sub totals for 2 labels that are in the same field. So to explain this graphically I have:

City           Dept         
------        --------
Region       Manager 1
               Staff 1
              Staff  1 Total
               Manager 2
                Staff 2
              Staff 2 Total

But want to get it like below if possible:

City           Dept         
------        --------
Region       Manager 1
             Staff 1
             Manager 2
             Staff 2
             Staff  1 Total
             Staff 2 Total

I was thinking I need to group the sub totals but playing about with it I couldn't get it to do anything like what I want, and search on google to no avial.

Thanks

Grifter

 

[NBVC]

I don't know that this is easily possible.

You can list the totals outside the pivot table, using SUMIFS to your original data. The numbers will change with database changes...

 

[grifter]

I don't know that this is easily possible.

You can list the totals outside the pivot table, using SUMIFS to your original data. The numbers will change with database changes...

That should be fine the data is a one off extract that isn't going to change. I will look into what you suggested,

Thanks

G