Rearrange Months in a Data set

[jlfromm]

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 

[Qiu]

@jlfromm 
I just answered a similar question.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Pivot-table-Format-Cross-Tab/m...

[caltang]

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.

[binuacs · Accepted solution]

@jlfromm Something like this