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
@Sergei Baklan Thank you very much!
@Shamesmarmar1981 , you are welcome