How to sort dimension by cyclic group expression

[sarafamiglietti]

Hello,

In my chart, I have expressions sum(nb_sales) and sum(nb_abo) which are in the same cyclic group and dimensions time and product.

Is it possible to sort my dimension "Product" depending of the expression displayed?

So:

If sum(nb_sales) is displayed, I want my Product sorted by sum(nb_sales) desc.

Il sum(nb_abo) is displayed, I want my Product sorted by sum(nb_abo) desc.

See file in example.

Thanks & Regards

[Michiel_QV_Fan]

If it is ok to show Product first on the x axis instead of day the you could simply use sort by Y value.

[sarafamiglietti]

Thanks you for your answer.

But in my case I must show day first.