Forum Discussion

Divasmo's avatar
Divasmo
Copper Contributor
Apr 21, 2022

hide in a pivot table values

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 ano...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 21, 2022

Hi Divasmo 

 

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

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

- Click Format > Number > Custom: ,,,

 

  • Divasmo's avatar
    Divasmo
    Copper Contributor
    Apr 21, 2022

    Lorenzo 

    Thank you so much,

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

     

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 21, 2022

      Divasmo 

       

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

      Good question...

Resources