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
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

@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

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Pivot table
gabriellerocha in Excel on
5 Replies