I have a calculated dimension in a pivot table and I am trying to highlight the 'actual' column if it's greater than the 'projected' column.
The actual calculation is working fine, but I can't get the background color to work properly. I have a feeling I made a stupid mistake but I can't get this last detail working.
Projected dimension is a static value related to the primary dimension Location.
Background Color: =if((aggr(sum(ActualDays),Location))>ProjectedDays,LightRed())
Desired Result (background instead of text color):
Each location has a static projected days number that is totally separate from other location projections. The actual days also link directly to each location which is why I tried the aggr direction. It just seems strange that the aggr Actual column calculation does not work when using it in an if statement with the background color, but it does work in a calculated dimension.