Set different "Sort by" for drill down chart

[Anonymous]

Hi guys,

Can I set different "sort by"s for different layers in a drill down chart?

For example,

I have a drill down group with four layers as a dimension.

1. Year

2. Agent

3. Order Number

The express is: sum(sales)

Of course I want the "Year" to be in acceding order. But I want the "Agent" and "Order Number" to be in descending order by "Y value" which is the sum of the sales.

How can I achieve this?

Thanks,

Lynn

[giakoum]

[Anonymous]

Thanks, but there is no option for "Y value" descending....

[giakoum · Accepted solution]

true, but you can use expression instead. The Y value is actually your 1st expression in the table, so you can replicate it here.

[JonnyPoole]

For the levels you need  'Y Value descending' , select expression and enter your expression sum(Sales) again . Descending.

[Anonymous]

Great!! It works. You are awesome!