add a calculated field in your pivot. Goto the analyze tab, then to the calculations group. Choose Fields, items & sets.
Next choose Calculated feld
In the next dialog select the first field you want to use for your calculation and click insert field. Typ the * and then click your second field from the list. Choos add field and then click OK.
A new calculated column will automatically be added to your pivot table.
hth
|