In a pivot table, you can create calculated fields, using formulas that work with the sum of other pivot fields. There are limitations to what a calculated field can do, but they let you add more power to your pivot tables.
Check out this link for additional information:
Obtained from the OzGrid Help Forum.
|How to group numbers in a pivot table|
|How to create a pivot table|
|How to work with Pivot Table multiple consolidation ranges|
|How to set dynamic dates for pivot table grouping|