Here's a workbook that shows how it can be done. The screenshot below highlights the key things I did.
I created a calculated field called Color which basically just turns the logic you stated above into code. I did it at an average aggregate level. That's the main thing.
To get the highlight table (with each cell highlighted by the color), I used another calculated field -- ONE -- which is simply hard coded as 1 and used the MIN to create the bar. You could of course just color the text.
I'd be happy to answer any questions you might have!
Laurie_Test_1.twbx.zip 1.3 MB
I wish I could give you 50 MILLION points buddy!! Thank you so much! I've been struggling with this all morning long!!
You're very welcome! Glad to help!