sort 100% stacked bar chart columns by legend value

[Anonymous]

Hi

I am attempting to sort an 100% stacked bar chart by the proportion of sales of a product group (i.e. Group with the highest proportion of ligh blue to lowest).

The data model has 3 tables. Group and product tables each joined to a sales table

Each product in the product table is catagorised as in the light or dark blue product group

Apologies if the solution has already been posted. I have read several that are similar but not been able to apply it to this (even though it seems simple on the face of it).

[lbendlin]

Please provide sample data in usable format (not as a picture) .