Forum Discussion
Shamesmarmar1981
May 12, 2019Copper Contributor
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
3 Replies
- SergeiBaklanDiamond Contributor
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
- Shamesmarmar1981Copper Contributor
SergeiBaklan Thank you very much!
- SergeiBaklanDiamond Contributor
Shamesmarmar1981 , you are welcome