I wasn't able to open the attachment because it seems to be from a version later than what I have (10). Not sure why.

But yes, that's exactly what I'd like to see, as you have shown in your screenshots.

Thanks, I played with that calculation and realized that it is not exactly doing what is desired.

What I'm trying to do is create a dynamic calculation based on the level of hierarchy shown in the viz. So if I have it collapsed all the way at Level 1, then show the calc for color aggregated to Level 1. However, if I expand down to Level 2, then the calculation should calculate the color for Level 2, but as I see, it is not doing that, and instead it is showing the Level 1-applicable color for all Level 2 items regardless of their % complete.

This is kind of a cube-philosophy that I am used to so pardon me but is something like that do-able at all?

Thinking more about it, I can see that this may be an impossible ask. The reason being, I am looking at Story % complete to calculate the Level 2 color, but I am looking for a completely different calculation for Level 1 color, which is "take the least performing Level 2 and show its color".

Let me know if this is possible at all:

For all dimensions except Level 2, calculate the color as "lowest" of all Level 2's and for any Level 2, calculate it based on the % complete for the Story included in each Level 2.