Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Could not really understand the issue.
Hi,
Please find the attached QVW.
Thanks,
JKM
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.
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)