Pivot table showing weeks in wrong order

[jitterbug888]

Hello,

My pivot table seems to number the weeks in incorrect order occassionally,
the data is coming from tab1 (data),
and the Analysis tab has the pivot table...

attached spreadsheet. Thank you.

Screenshot_20200417101042.png

[alansidman]

Place your mouse in the PT in cell A10.
Right Click and select Sort--> A to Z

[jitterbug888]

Thankyou! thats another way.

I clicked the filter menu drop down, and chose "week" from the submenu, then SORT A TO Z.
then did that again choosing MONTH, sort A TO Z.

appreciate your support!