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

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

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

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

Can I do calculations on already calculated fields in a pivot
 

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" wrote:

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

Can I do calculations on already calculated fields in a pivot
 

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.

--
Regards

Roger Govier


"Fen" wrote in message
...
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" wrote:

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