V
Vin
Hello,
Question about pivot table in Excel 2007.
In my pivot table I have two value fields, one displaying default count and
the other is a '% of row' version of same data. When I choose to have grand
totals disaplayed for the rows I naturally get two grand totals. One the sum
of the count and the other the sum of the '% of row'. The latter summing to
100% every time. I would rather not see this 100% grand total so I am
currently hiding the column.
Is this the best way to do that or is there a way to control which value
fields have a grand total calculated.
cheers
Vin
Question about pivot table in Excel 2007.
In my pivot table I have two value fields, one displaying default count and
the other is a '% of row' version of same data. When I choose to have grand
totals disaplayed for the rows I naturally get two grand totals. One the sum
of the count and the other the sum of the '% of row'. The latter summing to
100% every time. I would rather not see this 100% grand total so I am
currently hiding the column.
Is this the best way to do that or is there a way to control which value
fields have a grand total calculated.
cheers
Vin