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 ContributorShamesmarmar1981 , 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 ContributorSergeiBaklan Thank you very much! - SergeiBaklanDiamond ContributorShamesmarmar1981 , you are welcome