Belinda the GP CSI has a great video on the GL Summary Trial Balance made easy with Excel Pivot Tables.
Belinda, the GP CSI: GL Summary Trial Balance made easy with Excel Pivot Tables
General Ledger & FinancialsExcel & OfficeSQL & Data
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.