Pivot - Help on Creating Calculated Item

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?

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


"bchan" <bchan.1kjo2d@excelforum-nospam.com> wrote in message
news:bchan.1kjo2d@excelforum-nospam.com...
>
> 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?
>
>
> --
> bchan
> ------------------------------------------------------------------------
> bchan's Profile:
> http://www.excelforum.com/member.php...fo&userid=8274
> View this thread: http://www.excelforum.com/showthread...hreadid=345830
>

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


bchan wrote:
> 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?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html