Month-year (Apr-18) in Pivot table in an alphabetical order instead of chronological order

You're welcome. Thanks for the rep.


See the updated example. I have put the formula (=A2+0) in cell C2 and formatted as "mmm-yy", and then copied the formatted formula/format down. I have then inserted a new pivot table on the same page. Rather than selecting your Month column, I have used the new Date column.