sorting the year - month values in the axis of chart

[Anonymous]

Hi all ,

i have a dimension Year & '-' & Month used in the axis of a bar chart.

the sorting is not working fine.

the sorting of the years - months should  be in proper sort order

....

....

2015 - december

2016 - january

2016 - February

2016 - March

.....

....

Kindly help to solve this.

Thanks

[prma7799]

Go to Sort >> Sort by Expression >> Year & '-' & Month

[Lisa_P]

Go into the sort and sort by expression.

Use this expression:

(Year * 100 + Month)

[vishweshwarisun]

[olivierrobin · Accepted solution]

hello

you can sort on year and month number (not name) by using a key like

year number * 100 + month number

(if you sort on month name, december will appear prior to january)

[qv_testing]

By default Sort order Text(A-Z) format, if you un-check the Text format that should work proper sort order.

or

Sort tab--> in Expression (MonthYear)

[Anonymous]

Thanks Olivier

It worked!!