How to sort 100% stacked bar chat by value?

[IgalRiga]

I've done multiple searches and can't find this answer.

I have been able to sort all the green values first, then red, then blue which is correct. But now I am wanting WITHIN green, sort that, then WITHIN red, sort that.

So it should be based off the image below:

87.50% green first

then

83.33% green

etc.

After all the greens, sort the red highest to lowest.

I've already created and linked and sort/order table and that's what got me to this point of all greens first, then reds, then blues. 

[amitchandak]

@IgalRiga , The stacked legend can only sort by name, as part as I know