Can I do calculations on already calculated fields in a pivot tabl

[Guest]

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

 

[Roger Govier]

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

 

[Guest]

Hi Roger,
When I try to insert a field the only fields that seem to be available to me
are the ones in the raw data. What I do is on the pivot table toolbar I go
to Formulas/Calculated Field but only fields available to insert are the ones
from raw data. Am I doing something wrong?

Thanks,
Fenella

 

[Roger Govier]

Hi Fenella

Once you have created your first calculated field, and said OK, then
that field appears along with the list of "actual" fields in the white
pane where you can select and choose Insert.