Sorting in cyclical group - unsolved

[infock12]

Hi all,

I am struggling to make the cyclic group sorting work but not finding any luck.

I have 3 dimensions in a group. MonthName, Specialty and Consultant.

I went into Chart Properties>Sort, unticked everything and choose 'Override Group Sort Order'

I went into Document Settings > Document Properties > Groups > Edit, promoted the MonthName to first in the order.

I went into Sort Orders, chose MonthName and said Match(MonthName, 'Apr-15', 'May-15',etc.)

For Specialty, I chose Expression descending and copied the expression that I used in the chart (This is because I can't see a Y-value descending here).

For consultant, I followed the same above.

The outcome I am getting for Months is it starts with Apr-16 (instead of Apr-15) and goes up to Nov-16, and goes to Jan-16 (skipping Dec-15) and then Mar-16 (skipping Feb-16). The data does exists for those months and it is jumbled, so not sure why.

Any help is appreciated.

Thanks,

karthik

[infock12]

Thanks for the reply Sunny. When I try the 'Override Group Sort Order', it sorts the months correctly,but it is not allowing the other dimensions to sort by y-value (expression) descending.

[thomaslg_wq · Accepted solution]

You may need edit the group => sort order :

Month : numeric value ascending

Others : expressions ==> put the same measure as the one in the chart.

And in the chart, un select every check box in the sort otab.

This workaround should work

[infock12]

That worked perfectly Thomas!! Thank you very much.