sorting on a sub-category

[CharlesvanDortmond]

Hi all,

I have a stacked bar-chart which consists of N-number of categories; let's call them A,B,C. the x-axis is Customer and the y-axis is $-Revenue. When I build my chart I can sort on the $-Revenue, but this will sort Customers based on the order of the TOTAL $-Revenue... like this:

default sorting: total $ (sum of stacked categories)

I would like to be able to sort my graph on a selection of categories, like A or A&B.. while still seeing all categories in the graph. Like in the picture below where the sorting is done on $-Revenue for category C:

Sorting done on $-C only, while still seeing all categories

Can this be done? of so, how?

[Arthur_Fong]

Try this:

In sorting > select first dimension > sorting: custom> check sort by expression > sum({<Category={'C'}>}Revenue).

Dropdown select Descending.