Hi All,

I'm sure similar threads have been posted regarding my query, so apologies if this has already been answered.

I'm having a real issue getting data in a pivot table to sort correctly.

We have a spreadsheet containing a log of any praise/complaints received and I am using a pivot table to format the data and to produce a pivot chart.

The columns in the pivot table consist of the following.

January 2019 1
Praise 1
February 2019 2
Complaint 1
Praise 1
March 2019 2
Complaint 1
Praise 1

The problem occurred when I added a new record for May 2019. When I refreshed the Pivot Table I was expecting to see the May 2019 entry at the bottom underneath march, but instead it was inserted at the top.

I found some posts online that mentioned that it may be because it's formatted as text, which it is, but wouldn't May still appear under March in alphabetical order if that's the case?

Any help would be appreciated.

Thanks