Pivot drill-down - changing sort order

[fizzy]

Hi,

I have a pivot table set up showing spend figures against different categories, and I want people to be able to double click on the figure to drill down into it.

The pivot table is sorted by the spend figure column in descending order, so the highest spend is shown at the top. When I double click on the spend figure to drill down into the detail, the new worksheet is sorted by the correct column - but in the wrong order. The drilled down detail is sorted in ascending order, so I have to scroll to the bottom to get the large figures. I can sort the new sheet each time but I want it to automatically use descending.

How can I change the sort order for the drill down worksheets?

Thanks

[than_gold]

Hello Fizzy,
You can sort the double clicked data in Pivot table. Try below code.
Regards,
Thangavel D

Please Login or Register  to view this content.