Pivot table: can't sort Months in chronological order

Good evening,

This is my first post. I am a Pharmacy Technician but my new role involves organising, analysing, interpreting and presenting data. I have started using Excel recently. I need your help to sort out my pivot table and advice regarding "how to sort the month column chronologically".
The question reads:
Rivaroxaban
Dapagliflozin
Empagliflozin
Ticagrelor
but this time it's a new indication for an existing product so we need to see the monthly increase in spend i.e. April 2019 vs April 2020 but can be done as one increase for the whole group rather than individually like the list above.

I managed to get the data for the above anticoagulant drugs for 2019 and 2020 but doesn't know how to go about this?

Why can't I sort the months in pivot table chronologically?
How can I show the data as per requirement: to see the monthly increase in spend i.e. April 2019 vs April 2020 but can be done as one increase for the whole group rather than individually like the list above ?

Thank you in advance.

As you can see ( left alignment) your dates are not real dates but text looking like dates.
Replace them with real dates, and your Pivot will work as requested
To achieve this create a new column with following formula

Formula:

Please Login or Register  to view this content.

and Copy/Paste/Values on col A
Now refresh your PT

In your source data it is not entered as a date. You would be better served to have it as a date, ie. 4/1/2019 and then sort it in the PT.

Originally Posted by Jigneshbharati

Could you please elaborate on this? How do we know that the data in the Months column is not month or data type?

Click on a cell and select the number format. it it's a date you should get a number between 1 and 40000+
Also if no manual alignment is applied, text aligns left, and numbers right ( which is what a date is even if XL shows you something like 01/04/2009)
As my locale is different from yours, I cannot do it for you

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.