Pivot table- prevent auto sorting

[wayneryeven]

Hey all
Quick Q....i have a pivot table that already has the data sorted the way i want it. when i create a pivot table it auto sorts against the first field. How can i prevent this? Unfortuantely there is no straighforward sort ie. Ascending/Descending. The sorting is done in the query against various fields.

Thanks for all your time, effort and thoughts.

 

[Darrylles]

Hi wayner,

Have you looked at the query SQL? (Right-click the query - SQL).

You should be able to amend the order by clause there.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.