Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to sort the Months here in ascending order in the drop down menu for this filter pane in one of my sheets.
On the charts/visualizations, the months are sorted properly from Jan to Dec. I would like the same order for the drop down menu too, but had no success in doing so after trying out different sorting configurations while editing the sheet (See the sorting settings). Any advice would be appreciated.
(FYI, the first row in the dataset starts with a date in June last year, and continues up to Feb this year.)
Hi,
Trick is use monthno for sorting in your script add like following & then sort on month no this will sort like jan Dec
Month , MonthNo
Jan,1
Feb,2
Mar,3
Apr , 4
May , 5
June,6
July,7
Aug,8
sep,9
Oct,10
Nov,11
Dec,12
Hope this help you
Vikas
if you have calendar then incorporate this in calendar script
If(Num(Month(TempDate))>3,Num(Month(TempDate))-3,Num(Month(TempDate))+9) AS MonthNumber,
use monthnumber for sorting date.
Thanks
Vikas
Hi,
Trick is use monthno for sorting in your script add like following & then sort on month no this will sort like jan Dec
Month , MonthNo
Jan,1
Feb,2
Mar,3
Apr , 4
May , 5
June,6
July,7
Aug,8
sep,9
Oct,10
Nov,11
Dec,12
Hope this help you
Vikas
Thanks, @vikasmahajan for the suggestion. Can advise whether this syntax is to be addes in the data load editor or in the sorting expression?
if you have calendar then incorporate this in calendar script
If(Num(Month(TempDate))>3,Num(Month(TempDate))-3,Num(Month(TempDate))+9) AS MonthNumber,
use monthnumber for sorting date.
Thanks
Vikas