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

    Different colour of lines in pivot tables

      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,