2 colors alternatively in pivot Table

Fri, 20 Nov 2020 18:02:30 GMT

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

Re: 2 colors alternatively in pivot Table

tchovanec — Fri, 07 Aug 2015 01:09:32 GMT

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()))