Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
HI @bellesol
May be try like below
=If(GetCurrentField(NewGroup)='Year', Year, Month)
Here "NewGroup" is the cyclic group name