AutoSort by Field in Pivot not working

K

katie_c

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I have my file open, I select the ID field in the rows and go to advanced and instead of manual, I select AutoSort ascending by a summary field (YTD$). This works fine and refreshes correctly.

When I save the file and re-open it, the AutoSort has stayed as ascending, but the field has reverted to the ID field and not the YTD$, so its sorting on the wrong information.

Thanks,
Katie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top