Pivot table

W

WINDMILL

Would someone be able to tell me how to enter a calculation to subtract one
group from another in a pivot table, without having to modify the source data.
ex
group A has 6 items and a total
group B has 20 items and a total
there are several more groups
I would like to have a row within the table which subtracts B from A , not
effecting the other information
thank you in advance
 
L

Luke M

On the PivotTable toolbar, click the PivotTable dropdown button, and go to
formulas, then Calculated Field. You can now create a calculated field that
will apply mathematical operators to 1 or more of your previous fields.
 

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, range including subtotals 4
Complex Pivot Table Function 1
pivot table data 2
XL2007 - Pivot Table Limitations 2
Custom Calculation in a Pivot Table 1
Pivot tables - counting unique numbers 2
Inputing data into Pivot Table 2
Pivot table--and adjacent columns 1

Top