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?