Summery not in proper order

Question

Lately it seems all my reports are not summarized in order.

I have data that is by Fiscal Year and Month as a primary grouping in Summary tools. It comes out as follows -

Am I missing something? Since there is only one of each primary groupings, the subsequent groupings should not impact the order of this column (total number of jobs, outcomes, avg times, etc.)

FY / M (Approved)2022 / 032022 / 052023 / 072023 / 082022 / 042022 / 062022 / 122022 / 022022 / 092022 / 112022 / 072022 / 102022 / 012022 / 08

DataNath · Accepted Answer

@tim_koirtyohann is this what you're after? Your [FY / M (Approved)] field isn't a recognised date format that can be sorted and so in this approach I parse that into a properly-formatted Alteryx date (yyyy-mm-dd), use that to sort, and then remove it to clean the data set back up. Obviously if you want the dates the other way round, just change from ascending to descending in the sort tool.

tim_koirtyohann · Accepted Answer

yes I forgot about that tool. Thanks.