Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Change sorting expression to this
Only({1} Sales_MonthYear_number)
Thank you so much it worked