I have a cyclic group with different kind of dimensions in the group. In the sort, I want that if the selected dimension in the cyclic group is Time then sort alphabetically, otherwise sort by Y value
In the sort expression, I have put it something like this
if(GetCurrentField('sale dimensions') <> 'Time',
sum(saleamount)
)
So basically I have checked both the sort options by expression and then also checked the option sort alphabetically. I assumed that if the condition in the expression is not met, it will then sort alphabetically. This way if the selected dimension in the cyclic group is Time, it will sort alphabetically and if it is other dimensions, it will sort by y value
Hi Syed, in the "group configuration" dialog (Dimensions tab--> Edit Group--> Select group--> edit) you can set the sort for each field in the group (in the "Sort Fields..." button).
In there, select 'Alphabetical' for the Time fields and Sum(saleamount) for the other fields
