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 |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com