CUSTOM FIELD FOR PIVOT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can create a calculated field in the pivot table --

Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Field
Type a name for the field, and in the Formula box, enter a formula to
calculate the commission.
 
Back
Top