By creating a total field, moving fields to other areas, you can quickly summarize the data. By creating a Sum of Sales total field, moving the Sport field to the row area, moving the Quarter field to the column area, you can easily see how third-quarter golf sales stack up against sales for another sport or quarter, you can see grand total sales. - Microsoft Office PivotTable Component Help