hide in a pivot table values

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