Issues in Pivot alternate colors

[#1]

Hi All,

I am facing a lot of difficulties in getting alternating row colors to work on Pivot tables. I am able to get alternating row colors in straight tables either by selecting one of the styles, like Pyjama Green etc. or I can also write this code (if(Even(RowNo()),White(), Green())) and it works good.

But the problem is with Pivot tables. It does not work correctly. Can someone help here please. I have attached a sample file.

Please help!

Thanks

Raghu

[giakoum]

it does work if you put it in the expression background color. But maybe it is because of the sample values. Have you tried it with full values?

[Anonymous]

Here is an idea to try.  Use this color expression in each expression and dimension.  You may need to adjust your color pallet

color(mod(RowNo(),2)+1)

[qv_testing]

Hi Jagan,

Use this expression as Background color expression for all Expressions and Dimensions.

=If(Even(RowNo(TOTAL)), RGB(120,120,120), RGB(100,100,100))

PFA,

Hope this helps you.

----Raju

[juleshartley]

=IF(Even(rowNo(TOTAL)),LightGray(),White())

works as an expression background. I can't get it to work for the dimensions though...

[giakoum]

it is because dimension rows and expression rows are continuous numbers.

if the 1st row is a dimension it is 2, the 2nd being an expression is 2 etc.