Color Coding for alternate rows in a pivot table

[#1]

Hi,

I have a requirement wherein the rows of the pivot table must be represented via two colors red and green alternatively i.e., 1st row must be in red, 2nd must be in green, 3rd in red,4th in green and so on. Can anyone please let me know how this could be accomplished

[eduardo_sommer]

Use, in all dimensions and expressions of the pivot table, in the background property, the following expression

if (mod(rowno(total),2)=0,lightred(),lightgreen())

Eduardo

[jagan · Accepted solution]

Hi,

Try like

Chart Properties -> Expression -> Expand the + symbol for expression -> Click on Background and enter the following expression in Definition textbox

=If(Mod(RowNo(TOTAL), 2) = 0, RGB(255, 0 , 0),RGB(0, 255, 0))

Regards,

Jagan.

[#4]

Write the below expression in Expression + symbol(background color):

=if(even(rowno()),Green(),Red())

Hope this will help you.