Charts and Grouping orders

[knightwriter]

Hi All,

I have a chart and two groups options attached.

Is it possible to have option A sort by value and option B sort by month?

As per my screenshot below, you can see that the month (option B) is being sorted by value from option A.

Many thanks.

[stigchel]

You can use the sort by expression option, something like

If(GetCurrentField(Group)='Month',Num(Month), YourExpressionforValue)

[knightwriter]

Hi Piet,

Thanks for the note but unfortunately this does not work. Any other suggestions?

[Anonymous]

you can defne your sortorder in the Group definition

goto your group

select edit

right bottom you can define your sortorder for each Group member

that should work!

[#5]

Possibly if you define each separately using alternate states. You can define an alternate state in document settings --> General --> and in the middle you will see Alternate States... Define an alternate states, for example OpA, which you will then use within you chart properties etc. as the object ID

[pratap6699]

=sum(sales) is expression CyclicGroup is dimension

here we go to sort-->give expression =sum(sales) it display desending order quantity wise