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?
I believe that above() and below() doesn't work on Pivot Tables, only on Straight Tables or Charts that have an Straight Table equivalent.
Can you try this:
If(Sum(length) < Above(TOTAL Sum(length)), Red())
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.
Well, I guess there's something new to learn, hehehe. Thank you Sunny and Michael!
Retrieving data ...