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!!!!

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