Pivot - Help on Creating Calculated Item

[bchan]

Can anybody show me how to create a Calculated Item in a pivot table? I
have a field called CLASS with the following values: Stock, Sales,
Order and Target. I would want a field that calculates Stock minus
Order. As per HELP, we have to ungroup each item and enter the
calculation. I have done that but have never been successful in
creating one. Either the system hangs up or I get a message that
Calculated Item should be of the same field, which was how I defined
it.

Am I the only one who is having problem with this?

 

[JulieD]

Hi

i've not done a huge amount of calculated fields but they've always worked
for me ... my approach - put Class in the rows - drag stock & order to the
data area.

click on the pivot table icon and choose formulas then calculated field
give it a name (dif)
the next line has
= 0
i delete the 0
and in the field list click on stock, type a - and then click on Order
so i now have
= Stock- Order
click on Add

- is this what you're after.

Cheers
JulieD

 

[Debra Dalgleish]

To create a calculated item in the Class field:

Select the CLASS button in the pivot table, or select one of
the items in the CLASS field.
From the Pivot table toolbar, choose
PivotTable>Formulas>Calculated Item
Type a name for the item, e.g. Stock2
Press the Tab key, to move to the Formula box
In the Field list, select CLASS
In the Item list, double-click Stock
Type a minus sign
In the Item list, double-click Stock
Click OK