0
1
What is default sorting for excel 2010 pivot table and charts I have a "Year month Week" column in my data sheet which I am using as row label, excel pivot table renders it arbitrarily
like in data sheet I have data in the following order
2010 October Week 1
2010 September Week 1
2010 September Week 2
2010 September Week 3
2010 September Week 4
but when I use this in pivot table it generates row labels as
2010 October Week 1
2010 September Week 3
2010 September Week 2
2010 September Week 4
2010 September Week 1
I want pivot table to show row labels exactly in the same order as it is in data sheet
any one please :( – None – 2012-10-31T23:58:40.750
1I don't see that in Excel 2010, using the sample values you provided. By default Excel will sort the rows alphabetically, and the values you posted are already ordered that way. Maybe you have odd spaces in there somewhere? – None – 2012-11-01T01:04:12.063