CUSTOM FIELD FOR PIVOT

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
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Data 2
display all row fields in pivot table 1
Rank items in Pivot Table 3
Pivot Table Data Column Sort Excel 2007 1
Average of Subtotals in Pivot Table 0
Pivot Table and adding a % column, that is not in original data 3
Display No Data in Pivot 1
Pivot Puzzle 3

Top