Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grand totals in pivot table rows
I'm trying to remove the grand totals.
I have data label in "rows" and the same in "values" so i can count each unique text and count the number of times they appear, and then show that in a pie chart. any ideas on how to remove the grand total? it is showing as a separate pie slice and making the whole pie off. thank you!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grand totals in pivot table rows
On Wednesday, June 5, 2013 9:45:35 PM UTC+5:30, wrote:
I'm trying to remove the grand totals. I have data label in "rows" and the same in "values" so i can count each unique text and count the number of times they appear, and then show that in a pie chart. any ideas on how to remove the grand total? it is showing as a separate pie slice and making the whole pie off. thank you!!!! Just Check, under the Rows field of pivot, uncheck the show totals button |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grand totals Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Grand Totals | Excel Programming | |||
Pivot table row grand totals | Excel Discussion (Misc queries) | |||
Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals | Excel Worksheet Functions |