Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-561803%22%20slang%3D%22en-US%22%3EMy%20Data%20in%20Pivot%20Table%20contains%20zero%20values%20which%20I%20want%20to%20isolate%20from%20Pivot%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561803%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20to%20filter%20the%20zero%20values%20manually%20by%20filter%20in%20dialog%20menu%2C%20but%20the%20filter%20doesn't%20work%2C%20I'm%20still%20seeing%20these%20values%20in%20the%20pivot.%20Please%20assist%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-561803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562905%22%20slang%3D%22en-US%22%3ERe%3A%20My%20Data%20in%20Pivot%20Table%20contains%20zero%20values%20which%20I%20want%20to%20isolate%20from%20Pivot%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341004%22%20target%3D%22_blank%22%3E%40Shamesmarmar1981%3C%2FA%3E%26nbsp%3B%2C%20right%20click%20on%20the%20name%20within%20your%20PivotTable%20and%20select%20filter%20by%20value%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20463px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113125iDE8721F475902419%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAfter%20that%20show%20names%20for%20which%20sum%20is%20not%20equal%20to%20zero%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20521px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113127i6AA86A97E27F0E65%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564371%22%20slang%3D%22en-US%22%3ERe%3A%20My%20Data%20in%20Pivot%20Table%20contains%20zero%20values%20which%20I%20want%20to%20isolate%20from%20Pivot%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564643%22%20slang%3D%22en-US%22%3ERe%3A%20My%20Data%20in%20Pivot%20Table%20contains%20zero%20values%20which%20I%20want%20to%20isolate%20from%20Pivot%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341004%22%20target%3D%22_blank%22%3E%40Shamesmarmar1981%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Shamesmarmar1981
New 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
Highlighted

@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

Highlighted
Highlighted
Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies