Pivot table

[Guest]

I have created a pivot table from two spreadsheets and i have a pivot table
that looks something like this

Part NO STOCK PROVISION
A-401-1000 500.00 0.5
A-401-1001 250.00 0.8

I now want to have a field which multplies the stock by the provision so
that i am left with this

I have no idea how to add the field in and have really struggled with this :-(

Thanks


Part NO STOCK PROVISION TOTAL
A-401-1000 500.00 0.5 250.00
A-401-1001 250.00 0.8 200.00

 

[Guest]

Hi Kerry,

click on the provision (header) to select the cell

Select Pivot Table - Formulas - Calculated fiels and do the formula.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Kerry" escreveu: