Sorting Dimensions by Dates
Dates in dimension values are sorted as strings, which can be confusing. To make a date-type dimension appear in sorted order across the Dimension Grid, ensure that its data is returned into the datalayer as a DateTime value in ISO 8601 format (yyyy-mm-dd). To sort the dimension by Month and display the month number, you will need to manually setits Xolap Level element's Format attribute to MM once the wizard is finished. To sort it by Year and display the year number instead, set this attribute to yyyy.