Alternate Row colors in Pivot table

[#1]

Hi,

Is it possible to give alternate row color to  pivot table in the way I have given in the attachment?

I'm able to give alternate row colors for Manager and assistant manager using even(rowno()) and odd(rowno()) functions but 3,4,5 columns need more than 1 rows to be colored same hence I'm not able to use the rowno() function. Any help is appreciated.

Thanks,

JKM.

[tresesco]

Could not really understand the issue.

[#3]

Hi,

Please find the attached QVW.

Thanks,

JKM

[ThornOfCrowns]

OP requires that the rows in columns 'Technology', 'Ratings' and 'Percent' are coloured alternatively. I don't think it can be done in that pivot, but others may be brighter than me.

[yduval75]

You can add a field "Technology_number" with a load inline or other.
Then, use the function as you have done but with the new field : even(Technology_number) or odd(Technology_number)