4 Replies Latest reply: Dec 5, 2017 1:47 PM by Rodolfo Souza RSS

    How to change background color in pivot table by expression ?

    Layla Mar

      Hi all,

       

      I want to show top 3  in green and bottom 3 in red.

       

       

       

      If ( sum ( sales) > .5, rgb ( 255,0,0,)) 

       

      Which function do I use to return top 3 or bottom 3 ?