MS Excel: Hide zero value lines within a pivot table in Excel 2011 for Mac
Question: Is there a way to hide zero valued lines within a pivot table in Excel 2011 for Mac? i.e. I have a table with two columns Order ID and Total (Sum of Quantity) and I would like to hide the Orders with no quantity total against them - is this possible?
Answer: Let's take a look at an example. Below is a spreadsheet that contains values that are zeros. We want to hide these lines 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 drop down box and 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 zero lines should be hidden.
