Good afternoon, Community,
I have a parameter, pictured below, that controls every sheet in the workbook, it points to a date field that is Month/Year... I cannot for the LIFE of me get it to put 2022 on the top and oldest on the bottom. There has to be some way to force this with a parameter, right?? I have tried right click on the actual date field my parameter points to and tried fiddling with the sort options and absolutely nothing changes the sort order. What am I missing?
Many thanks!
-A
6 answers
create a parameter now using this field or drag this field to new sheet and check what you get.