When working with Excel Report Builder you can choose to skip sending data to GP and have ERB setup a pivot table instead.
Simply change the Report Type to Pivot Table and save the report.
Weekly Dynamic: Excel Report Builder Pivot Table
Reporting & BIExcel & OfficeTips & Hidden Features
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.