Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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)
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
=IF(Even(rowNo(TOTAL)),LightGray(),White())
works as an expression background. I can't get it to work for the dimensions though...
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.