Onza covers Excel Report Pivot Tables in GP 2010 in their latest blog post.
Feature of the week: Excel Report Pivot Tables in GP 2010 | onza blog
Reporting & BIExcel & OfficeSQL & DataGP 2010
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.