12 Replies Latest reply: Sep 7, 2015 7:56 AM by Harshitha Harshu RSS

    Different colour of lines in pivot tables

    Hasvine Dhurmea

      Hello All,

       

      I usually use this expression to make 1 line white and 1 line grey in my normal table:

       

      =if(mod(rowno(TOTAL), 2) = 1,  white(), rgb(212,212,212))

       

      However, it is not working in a pivot table.

       

      Any idea why I do not get the same result on my pivot table.

       

      Many Thanks,

       

      Hasvine