color expression with above function not working

[mgranillo]

My color expression if(sum(length)<above(sum(length)),red()) does not work if my table has multiple dimensions.

How can I have this expression work with multiple dimensions?

[alexdataiq]

I believe that above() and below() doesn't work on Pivot Tables, only on Straight Tables or Charts that have an Straight Table equivalent.

[sunny_talwar · Accepted solution]

Can you try this:

If(Sum(length) < Above(TOTAL Sum(length)), Red())

[mgranillo]

Wow, such a simple change.  Thanks Sunny!  This wouldn't have occurred to me. 

To Alejandro, I tried converting the pivot to a straight table but the color expression still wouldn't work if there were two dimensions.

[alexdataiq]

Well, I guess there's something new to learn, hehehe. Thank you Sunny and Michael!

Cheers