Exclude zero values from pivot

**heytherejem** · 07-01-2022, 09:45 AM

I have tried following online guidance to remove zero values from a pivot, I've managed to hide them so the values are blank now but the rows are still in the pivot.
I want to exclude them entirely from the pivot, is there a way to do this?

**Pepe Le Mokko** · 07-01-2022, 10:14 AM

A couple of suggestions https://www.extendoffice.com/documen...ro-values.html

Exclude zero values from pivot

LinkBack

Thread Tools

Rate This Thread

Display

Exclude zero values from pivot

Re: Exclude zero values from pivot

Thread Information

Users Browsing this Thread

Similar Threads

Can a Pivot Chart selectively exclude data in the Pivot Table? NO ONE HELPED ME ... :o(

Copy values from Pivot Table but exclude certain data based on cell value

Hide/Exclude Null Values in Pivot table

Stop Pivot Table Counting NULL Strings and exclude them from pivot data summary selection

Exclude zero values from pivot table

Exclude zero values using average function in a pivot table

[SOLVED] Pivot table-How to exclude zero values from it.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions