MS Excel 2011 for Mac: Suppress zeros in a pivot table on Totals displayed as a percentage of the Grand Total
This Excel tutorial explains how to suppress zero values on pivot table totals displayed as a percentage of the grand total in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, how do I suppress zeros in an Excel pivot table after using 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 lines (ie: row 4) from being displayed in the pivot table.
Click somewhere in the pivot table to display the PivotTable Builder.
Drag the Quantity field from the "Field name" box to the Report Filter section. You should now see a Quantity drop down appear in row 1 in your spreadsheet.
Click on the arrow to the right of the Quantity drop down box and a popup menu will appear. Un-select the checkbox next to the 0 value and click on the X in the top left of the Quantity window.
Now when you return to the spreadsheet, the Totals with a value of 0 should be hidden.
Advertisements