I created a pivot table and it is counting my items so I change the value to sum of count. Whenever I do this, it changes all my numbers to zero instead of inserting the value of those fields.
Question:How do I suppress zeros in a Microsoft Excel 2003/XP/2000/97 pivot table afterusing the show values as a % of grand total? Answer:Let's look at an example. Below is a spreadsheet that contains Totals displayed as a percentage of the Grand Total. We want to hide the zero lin...
I created a pivot table and it is counting my items so I change the value to sum of count. Whenever I do this, it changes all my numbers to zero instead of inserting the value of those fields. Nina_D1985