Customizing Pivot Table Totals

  • Thread starter Thread starter DLG
  • Start date Start date
D

DLG

When i set the options to Total a row I get totals for all 10 of my data
fields, which would be fine, except 3 of these data fields should not be
included in the display of totals. Is there some settings that I can
configure so that certain data fields are not inlcluded in the totals? Below
is an example

City Project Type Data Jan Feb
1 a Houses 4 5
Cost 3 6
People 12 3
b Houses 5 11
Cost 4 10
People 10 5
City 1 sum of Houses 9 16
City 1 Sum of People 22 8
2 repeat above

Note that there should not be a sum of the Cost data item below each City

TIA
Dean
 
You could use conditional formatting to set the font for those fields
to white colour, so they won't be visible.
 
Back
Top