I have a date set where the months in alpha order and I would like them to listed from July - June instead. Each month is listed as a row and then I have information in the column that pertains to that month.
Thanks
@jlfromm Something like this
@jlfromm I just answered a similar question.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Pivot-table-Format-Cross-Tab/m-p/1251569/highlight/true#M311741
Better use MonthNo and then sort that instead if you can. You can use a Formula Tool to generate the MonthNo from your date field.
