sorting stacked bar chart with 3 dimensions

[#1]

Hello,

I have a problem to sort the bar segments within a stacked bar chart.

Attached you can see my bar chart and a table for the explanation.

What i would reach is that within each year the bars are sorted according the total of the group (in my example CNG, SSC, TSC, ACSV because the totals are 514/292/146/88) and within each group the sorting should be the single count value. This means within CNG i would like to have first the 2, 1, 3, 4 because of the values like 283/ 147/ 81/ 3

Can someone help me to reach this goal?

Thanks, Armin

[Gysbert_Wassenaar]

Three dimensions? I only see two. Perhaps this discussion helps: Bar Chart 2 Dimentions sorting

[#3]

Sorry for the confusion, for the bar chart i have combined group and the type that i can generate stacked bars. But the sorting of this combined bars should be according the 3 dimensions as explained above.

[Gysbert_Wassenaar]

Please post a small qlikview document that illustrates the problem