Forum Discussion
My Data in Pivot Table contains zero values which I want to isolate from Pivot report
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
Shamesmarmar1981 , right click on the name within your PivotTable and select filter by value
After that show names for which sum is not equal to zero
SergeiBaklan Thank you very much!
Shamesmarmar1981 , you are welcome