If you would like to perform this
exercise with the same data you can download the sample file (Salaries.zip)
using the link below. The ZIP file contains two copies of the
Salaries workbook, one in .xls format for Excel 2003 and
earlier and one in .xlsx format for Excel 2007 and later.
Part three of three tutorials introducing Pivot Tables in Excel
2007/2010. Demonstrates how to group and ungroup fields in the table
and add subtotals to the groups, how to rearrange rows, and how to
specify how data is summarized.