
Creator III
2023-11-20
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sort - Month(Date)&'-'&Year(Date)
Hi All,
I am using Month(Date)&'-'&Year(Date) expression in my dimension in bar chart and i want it to be sorted Month and then year wise, Ex-
Jan-13, Feb-13.. and so on.
I see that the expression has been sorted properly but for some reason Oct-2013 and Nov-2013 is getting displayed at the end after Sep-2017.
Please help me get this fixed.
Thanks,
Raju
1 Reply


Partner Ambassador/MVP
2023-11-20
01:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try instead to create your dimension as
=Date(MonthStart(Date), 'MMM-YYYY')
and then check Numeric for Sort type.
-Rob
