I know I am probably doing something wrong and it is a simple case of ticking a box but I have data which is in my Pivot Table Rows area. However, when it appears on the Pivot Table it has changed order to alphabetical but I need it to stay in the same order as the data table.
This is the order in Data Table (that I want to have in the Pivot Table also):
Eastbourne
Richmond
Malvern
Exeter
Cheltenham
Birmingham
Manchester
Inverness
Glasgow
Edinburgh
This is the order in Pivot Table (which I don't want):
Birmingham
Cheltenham
Eastbourne
Edinburgh
Exeter
Glasgow
Inverness
Malvern
Manchester
Richmond
Am I doing something wrong???
This is the order in Data Table (that I want to have in the Pivot Table also):
Eastbourne
Richmond
Malvern
Exeter
Cheltenham
Birmingham
Manchester
Inverness
Glasgow
Edinburgh
This is the order in Pivot Table (which I don't want):
Birmingham
Cheltenham
Eastbourne
Edinburgh
Exeter
Glasgow
Inverness
Malvern
Manchester
Richmond
Am I doing something wrong???