Hi Fenella

You can use either existing Fields or Calculated fields when defining
other formulae in the PT.
Suppose your raw data has Product, Volume and Cost
You can insert a calculated filled with the Title Average Cost defined
as Cost / Volume
You could insert a field called Standard Cost and define that as a
static figure, e.g. 15
You could then insert a field called Cost Variance defined as Average
Cost - Standard Cost


--
Regards

Roger Govier


"Fen" wrote in message
...
I have already calculated a pivot table that has Total Volumes and
Total
Costs as fields in it. Can I do a further calculation within my pivot
table
on these calculated figures to calculate the Unit Cost = Total
Volumes/Total
Costs? Or can you only do calculations on the orginal data not on the
calculated fields?

Thanks,
Fenella