hide in a pivot table values

%3CLINGO-SUB%20id%3D%22lingo-sub-3290941%22%20slang%3D%22es-ES%22%3Ehide%20in%20a%20pivot%20table%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290941%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CFONT%3EDear%20good%20afternoon%2C%20I%20hope%20you%20are%20well.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EI%20need%20your%20help%2C%20I%20have%20the%20following%20pivot%20table%2C%20where%20I%20want%20to%20hide%20in%20the%20%22variation%22%20column%20the%20zero%20values%20and%20the%20negative%20values%20and%20in%20another%20table%20the%20zero%20values%20and%20the%20positive%20values%2C%20then%20extract%20from%20the%20pivot%20table%20In%20mention.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Divasmo_0-1650515780256.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365744iB92E6F389A51DE7B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Divasmo_0-1650515780256.png%22%20alt%3D%22Divasmo_0-1650515780256.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EAttach%20file%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3Ethanking%20you%20in%20advance%20for%20all%20your%20help.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EBlessings%2C%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3290941%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3291038%22%20slang%3D%22en-US%22%3ERe%3A%20hide%20in%20a%20pivot%20table%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3291038%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F643669%22%20target%3D%22_blank%22%3E%40Divasmo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Select%20one%20of%20the%20Variacion%20%22column%22%20(both%20will%20be%20auto.%20selected)%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22_Screenshot.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365762iC4A3D72C80BD5B8E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22_Screenshot.png%22%20alt%3D%22_Screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E-%20Go%20to%20Home%20(tab)%20%26gt%3B%20Conditionnal%20Formatting%20%26gt%3B%20New%20Rule...%20%26gt%3B%20Set%20the%20rule%20as%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22_Screenshot2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365763iBB9253B5F95CE0A6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22_Screenshot2.png%22%20alt%3D%22_Screenshot2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E-%20Click%20Format%20%26gt%3B%20Number%20%26gt%3B%20Custom%3A%26nbsp%3B%3CSTRONG%3E%2C%2C%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear good afternoon, I hope you are well.

 

I need your help, I have the following pivot table, where I want to hide in the "variation" column the zero values ​​and the negative values ​​and in another table the zero values ​​and the positive values, then extract from the pivot table In mention.

Divasmo_0-1650515780256.png

 

Attach file

 

thanking you in advance for all your help.

 

Blessings,

3 Replies

Hi @Divasmo 

 

- Select one of the Variacion "column" (both will be auto. selected): 

_Screenshot.png

- Go to Home (tab) > Conditionnal Formatting > New Rule... > Set the rule as below:

_Screenshot2.png

- Click Format > Number > Custom: ,,,

 

@L z. 

Thank you so much,

but what I need is something as per the image below:

Divasmo_1-1650551279810.png

 

@Divasmo 

 

Much more clear: you want to hide the rows where the [Varicion] is > 0 (or < 0 in the other Pivot)

Good question...