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

[Fen]

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


--
Regards

Roger Govier


"Fen" <[email protected]> wrote in message
news:[email protected]...
>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

[Fen]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>>
>>
>>