Hi to all you smart people out there,
i need help with organize items in select control.
im sorry but i dont have dummy table for this but it would look like this:
One table with column where are dates, from this column i extract to next column the name of the month with MonthName function. Everything is easy for now.
Then outside the table i add select control where i make unique list from the months column. Also easy but the list is not sorted or it can be sorted alphabetically but i cant sort the list by month (january, february, march…etc). I also did in that table next column with function Month, where i get the number of the month but i cant get it working with sort function.
Then i want to filter that table with this select control.
thanks for help
P.S.: if needed i can do that dummy table