Sort order issue in combo chart

[Nivetha_AZ]

Hi,

I have created a combo chart which displays rolling 12 months data

Dimension : Sales_MonthYear
Expression: sum({<Sales_MonthYear_number={"<=$(vStartmonth)>=$(vEndMonth)"}>}sales)
Sort order: Sorting for Dimension 'Sales_MonthYear' is set to 'Custom' and have used the 'Sales_MonthYear_number' field.

By default, the sort order is working as expected but when rolling 12 months condition is applied, the sort order on month is not working.

Sorting for Sales_MonthYear is Custom and have user the Sales_MonthYear_number field.

I have attached the screenshots of the sorting condition and the chart

[sunny_talwar · Accepted solution]

Change sorting expression to this

Only({1} Sales_MonthYear_number)

[Nivetha_AZ]

Thank you so much it worked