Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Guys, i can't change a brackground color in my pivot table...What i did wrong?
For example, i have two dimension, NPS and Hour...in expession i count how many coupon i had for day, in the end make a %...ok.
But i want make a condicion...if % => 50%, green(), if %>=20 and %<= 49 yellow()...and so on so forth....
but when i do this in backgroud color, nothing happens...but if a do the same formula in Text Color it works...why?
Someone can help me?
Thank you!!!
Hi Mathews,
For background color on a column expression, click on the plus sign and choose background color, then write something like :
if(((Column(2)-Column(3))/column(3))>=0,rgb(90,249,32),rgb(249,35,2) )
This give you a percent from columns 2 and 3... colored by red or green using rgb values.
I hope this tip could serve.
Have a great day!
Hi Mathews,
For background color on a column expression, click on the plus sign and choose background color, then write something like :
if(((Column(2)-Column(3))/column(3))>=0,rgb(90,249,32),rgb(249,35,2) )
This give you a percent from columns 2 and 3... colored by red or green using rgb values.
I hope this tip could serve.
Have a great day!
Thanks...But a find the problem.
Cell Background color transparency was 100%...
Sorry!!
Any time, your welcome. H