Pivot table
 

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

Pivot table
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"WINDMILL" wrote:

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