In a chart I have a calculated date dimension to get the year and the month, like this:
year & '-' & month
but I'm unable to sort this dates, any ideas?
thanks in advance!
use year * 100 + month, in this way you will have always numbers of 6 digits ex. 201401, 201402 ...
Sorting in this way is natural
Hope it helps
Great! Worked like a charm, thanks Alessandro.
Try this in your sort expression
Retrieving data ...