Calculated field in a pivot table?

[Divya]

i need to create a calculated filed in a pivot Table

for example: Qty/Options

based on "Sum of Quantity" and "Count of Option" fields in a pivot table.

 

[Ashish Mathur]

Dear Shilpa,

May I request you to upload the workbook on in the forums. Alternatively
(if you cannot do so), please mail the workbook tome at (e-mail address removed)
and explain the problem very clearly.

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

 

[Santhosh Mani]

Hi Divya
If you are using Excel 2003 select any cell under Qty or option then Menu -
Insert > Calculated field. You will get Insert calculated field screen. Write
a name for the new field, then click inside the formula area, then insert the
filed Qty from the list below.. type / .. then insert options field from
list.. click Add. thats it..

If you are using Excel 2007 Pivot Table Tools.. Options... Formulas ..
insert calculated field.. and the rest is same as above

Santhosh

 

[Dave Peterson]

This is a text only newsgroup.

Attachments are not welcomed by most users.

If you want the OP to send you the file, then no problem.

If the OP wants to use a web site like www.savefile.com and post a link to the
uploaded file, then that's fine, too.