ExcelBanter - I want to hide data that's less than 1 in a pivot table

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

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

- - I want to hide data that's less than 1 in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/184803-i-want-hide-data-thats-less-than-1-pivot-table.html)

SDixon578

I want to hide data that's less than 1 in a pivot table

I ahve this pivot table in a worksheet that picks up a load of info, but I
only want to see what has data less than one. Is there any way to filter it?

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