Pivot table row stripping based on top level

[#1]

Hi

I think I am nearly there, just need a little guidance.

I want to shade every other PivotTable row based on the first dimension level.

Thanks

Oli

[Carlos_Reyes · Accepted solution]

Try:

=if(sum( total <Parent> odd(aggr(rowno(),Parent)))<0,rgb(160,160,160),rgb(255,255,255))

[#3]

Thank you