Can one create a custom field in mid of a pivot table. For instance:

1. Original PIVOT TABLE
Sales Zone 1 Sales Zone 2 Sales Zone 3 Total

2. Custom PIVOT TABLE
Sales Zone 1 Sales Zone 2 (Net of Commission in Zone 2) Sales Zone 3 Total