My pivot table data base is set up as follows:

Fields:
A B C D

The pivot table layout is set up as follows:
COLUMN (NOTHING)
ROW
A DATA AREA = SUM OF D
B

When I drill down on a "D"output cell in the pivot table the data shown is A, B, C, D and is sorted in descending order based on C. How can it get the drill down data sorted in ascending order based on C?

Look forward to your responses and thanks!