Conditional color based on % to Total

[dwh1104]

I am able to get the % to total values to display properly in my pivot table.  Now, I would like to display the following background color formatting as it is in Excel.  ([PS Department Group] and [KPI Month] (going across) are both dimensions.

Red where the % for individual month is less than TOTAL % for all months.

Green where the % for individual month is greater than TOTAL % for all months.

Any help is greatly appreciated!

Thanks,

Dan

[dwh1104]

Thanks Eduardo.  I was able to work out the background color expression for my issue, based on the expression you provided.