2 colors alternatively in pivot Table

[#1]

Hi All,

I have a requirement where I need to make alternate color as a bar in pivot table. I don't think one can do it using linear guage.

I tried using the text by having the following formula

=repeat(chr(num#('2588','(hex)')),
Round(Sum( REACH_COUNT) /
Sum( TARGET_COUNT)*7.5))

This gives me a text and using this formula and going in text color I can apply the if condition and get the alternate color.

Is there a better solution than this? where one can have more than one color in pivot table using Linear Gauge or any other way.

Regards,

Max

[tchovanec]

Try adding something like this to the background color of your expression.

IF(rowno() = 0, rgb(255,255,0), if(even(rowno()),rgb(215,215,215),white()))