Pivot tables

Hi Lynne, thanks for your query. You can't change the nature of the grand total column because that is wired into the pivot table tool itself. However, you could create a custom calculated field which would perform a difference calculation and which you could then add to the pivot table in place of the grand total column.

Hope this helps,

Anthony