formatting pivot with alternative colors

[m4u]

Hello, I want to make a pivot table morer readable by showing the result in alternating color, say 1st line is white, 2nd line is grey, 3rd line is white.... etc Is there any way to do such formatting?

i tried this:

if(mod(rowno(), 2) = 1, rgb(215,215,215), white())

this is good if my column dimensions contains allot values, since rowno() returns the number of the row within the dimension.

how colud i get the row number in the full pivot regardless a specific dimension.

thanks

shlomo

[matt_crowther]

Try using 'rowno(total)' instead - this will run across all values in your primary dimensions.

Hope that helps,

Matt - Visual Analytics Ltd

[m4u]

great !!!

thanks