My Data in Pivot Table contains zero values which I want to isolate from Pivot report

Copper Contributor

I tried to filter the zero values manually by filter in dialog menu, but the filter doesn't work, I'm still seeing these values in the pivot. Please assist

 

3 Replies

@Shamesmarmar1981 , right click on the name within your PivotTable and select filter by value

image.png

After that show names for which sum is not equal to zero

image.png