excel pivot table sorting

Question

How pivot table sorts data in row label and column label

It resulted quite strange to me.

as source sheet has a column with data in format "year month week" (e.g 2012 10 wk 4) as text data

when using this column as row label and column label in pivot it resulted as

2012 08 wk 4 2012 09 wk 1 2012 09 wk 4 2012 09 wk 3 2012 09 wk 2

source sheet has data in correct order 2012 09 wk 1, wk 2, wk 3, wk 4... but when using it in pivot table disturbs the order which should be as in source sheet

Answer 1

You might need to right-click on the say the first row where a value you wish to sort appears (eg where it says '2012 08 wk 4') and choose the sort menu option from the right-click menu.

In the image below, I right-clicked on the value 896,321......