Hello,
There is a date field, loaded in the format YYYYMMDDHHmmSS
I am using this field in a drilldown group as dimension to display month, week and day
Expressions used are
=month(date#(Mid([datefield],1,8),'YYYYMMDD'))
=Week(date#(Mid([datefield],1,8), 'YYYYMMDD'))
=
date(date#(Mid([datefield],1,8), 'YYYYMMDD'),'MM/DD/YYYY') There is data from Oct 2014 to Jan 2015,
currently I am sorting with numeric option, so it displays Jan first. (Jan, Oct, Nov, Dec)
But actually I want to sort it in below order
Oct
Nov
Dec
Jan
Please suggest how can I do this.