This content has been marked as final. Show 2 replies
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.
Thanks in advance for any help.