Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()))