Pivot Tables - Item Order
I am using pivot tables in Micrsoft Excel. The problem I am having is when I try to sort the data in ascending/descending order. The data in ascending order should be of the form 1.1.1, 1.2.1, 2.1.1 ....9.9.8, 10.1.1 etc. The sort mechanisim in the pivot table sorts it as 1.2.1, 10.1.1, 2.1.1 etc.
I want to sort it numerical via the first number, then the second number etc. The option to sort it as the source data is no good in this case.
Does any one have any ideas?
Re: Pivot Tables - Item Order
I think you are at the mercy of Excel when it comes to pivot table sorting.
One option is to have a designated sort numeric field that sorts the 1.2.1, 10.2, etc. and you use this field in the pivot table.
Another option is to format the 1.2, 10.10, 9.9 as 01.02, 10.10, 09.09. Padding with sufficient zeros will create a correct sort.
ww