hide in a pivot table values

Question

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.

Attach file

thanking you in advance for all your help.

Blessings,

lorenzo · Answer

Hi&nbsp;Divasmo&nbsp;&nbsp;- Select one of the Variacion "column" (both will be auto. selected):&nbsp;- Go to Home (tab) &gt; Conditionnal Formatting &gt; New Rule... &gt; Set the rule as below:- Click Format &gt; Number &gt; Custom:&nbsp;,,,&nbsp;

divasmo · Answer

Lorenzo&nbsp;Thank you so much,but what I need is something as per the image below:&nbsp;

lorenzo · Answer

Divasmo&nbsp;&nbsp;Much more clear: you want to hide the&nbsp;rows where the [Varicion] is &gt; 0 (or &lt; 0 in the other Pivot)Good question...

Forum Discussion

hide in a pivot table values

3 Replies

Resources