At CFO.com, Mr. Excel, Bill Jelen looks at a way to Tame Pivot Table Sequencing. Once you get data out of GP and into Excel it helps to know what to do with then.
Tame Pivot Table Sequencing
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.