I have a table where each row is assigned a month (single select field).
When I group by month, it only allows me to sort by alphabetical order or reverse, which doesn’t make sense if I’m grouping by month. If I group by month and then sort by alphabetical order, it shows April first, which doesn’t make sense.
I would like to add custom sorting options when using Group By. In this example, I could Group By month and then sort by a custom field where I assign each month a number that puts them in the correct order.
If I can’t order the data the way I need, I simply can’t use the Group By feature.
TIA!