2 Replies Latest reply: Mar 18, 2014 2:29 PM by Alberto Gugel RSS

    Pivot Table - Dimensions/Expressions background color issue

    Alberto Gugel

      Hi there, I am currently facing a strange issue with my pivot table. The problem is that, when I try to color dimensions or expressions background by means of the following expression:

      =if(mod(rowno(),2) = 0, rgb(216,216,216))

      As a result, one empty row seems to be added to the table and I can't figure out the reason why this is happening.

       

      I tried also to avoid row # 0 with this:

      =if(rowno() <> 0,if(mod(rowno(),2) = 0, rgb(216,216,216)))

      but the result is always the same, as shown in the picture below.

       

      Immagine1.png

      Thanks in advance for any help.