Please find my solution attached with 10.2 since I don't have earlier version installed.
Below is the screenshots of steps just in case you can't open the workbook.
Create 3 calculation fields:
Use calculation 3 as the color and set up the table calculation, and choose the corresponding color
I attached workbook for reference, but if you can't open it and you have question about reproducing it from above screenshot, just let me know.
Scorecard Example File_v10.2.twbx 171.8 KB
Thanks so much. I was even able to do the Color Coding for the Quarters compared to the last quarterly forecast :-)
1 of 1 people found this helpful
No worries, Milton,
This is really an interesting case