Jan Harrigan looks at Using FRx or Management Reporter to create an Excel Pivot Table at the ever valuable FRx Buzz.
Using FRx or Management Reporter to create an Excel Pivot Table | FRxBuzz
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.