Pivot table background color with 3 conditions

[laumartinezb]

Hi all!

I'm trying to define the background color for my pivot table. I want to use 3 colors depending on the following conditions:

- IF((Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])>Expected,RGB(0,255,0))

- IF((Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])<Expected and (Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])> Minimum,RGB(255,200,25))

- IF((Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])<Minimum,RGB(255,0,0))

I would like to combine the three expressions in order to have all the conditions in the table, but I have only managed to use the second one.

Thank you very much in advance!

[fosuzuki · Accepted solution]

Try this:

IF((Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])>Expected,RGB(0,255,0), IF((Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])<Expected and (Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])> Minimum,RGB(255,200,25), IF((Sum([Total Tickets])-Sum([Total Breaches]))/Sum([Total Tickets])<Minimum,RGB(255,0,0))))

[ArnadoSandoval]

@laumartinezb 

You may found the suggestions given in this topic helpful Conditional colour formatting calculated measure/attribute 

Hope this helps,