cyclic group sort

[bellesol]

Hi,

I have one cyclic group in my model and I use it in a table and in a graph,

so when a user selects for example - "year", he see data by "year" in the graph and in the table,

The problem is the sort,

I used the sort in the group edit,

Is it possible to change the sort of the cyclic dimension  based on the chart? so that the sort in the table will be descending while the graph will be ascending?

I have  5 dimension in the cyclic group, and in some of them I use expression for sorting.

Thanks !

[MayilVahanan]

HI @bellesol 

May be try like below

=If(GetCurrentField(NewGroup)='Year', Year, Month)

Here "NewGroup" is the cyclic group name