Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Go to Sort >> Sort by Expression >> Year & '-' & Month
Go into the sort and sort by expression.
Use this expression:
(Year * 100 + Month)
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)
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)
Thanks Olivier
It worked!!