Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey!
I have a problem with my horizontal filter pane is sorted alphabetically on my month variable.
I would like to sort it such that it shows: Jan | Feb | Mar | and so on
This is how it looks now.
Can anybody help here?
There are various ways to handle it. I use Dual in the script for the month field to be used in the filter to show formatted as month but date type internally e.g. Dual(Date(Monthfield,'MMM'),floor(Monthend(MonthField)))
Once the type is set as date it can be sorted as asc/desc the way desired.
Thanks,