Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Monu
Try Sort by Expression Date(Monthstart(Date),'MMM-YYYY')
Thanks ! Makes sense, but did not work.
Hi,
why don't use
MonthName(Date)
instead of Month(Date)&'-'&Year(Date) ?
MonthName() is Dual Function.
=MonthName('13/06/2017')
Regards,
Antonio
sort by
max(Date)
Just give a try by using Date(Monthstart(Date),'MMM-YYYY') as Dim and sorting check Numeric ascending/descending
Thanks All for ur response!
Massimo, your suggestion worked. Thank you !