Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table row grand totals
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Pivot Table: How to modify sub and grand totals ? | Excel Discussion (Misc queries) | |||
Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals - Hide Some, Not All | Excel Discussion (Misc queries) | |||
Grand Total on Pivot Table turned on but no totals showing | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals | Excel Worksheet Functions |