Pivot Table - Dimensions/Expressions background color issue

[googel84]

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.

[MK_QSL]

The below should work.. It's working fine in my apps.

I not working in your apps, please upload your sample apps with reduced data... or dummy apps.

=IF(MOD(RowNo(),2)=0,RGB(216,216,216))

[googel84 · Accepted solution]

Fixed!

There was an issue with the underlying data; once I have fixed that, the above formulas work perfercly.

Thanks anyway