ExcelBanter - Pivot Table Supress rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Supress rows (https://www.excelbanter.com/excel-discussion-misc-queries/142851-pivot-table-supress-rows.html)

John

Pivot Table Supress rows

I have built a pivot table that has line items for a field, but the value is
0. I would like to supress the lines that that have zero in them so I can
only see the lines that have a value in them.

Any Ideas how to do it?

All times are GMT +1. The time now is 07:12 AM.