Calculated field in a pivot table?
 

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.

Calculated field in a pivot table?
 

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
and explain the problem very clearly.

--
Regards,

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

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

Calculated field in a pivot table?
 

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

"Divya" wrote:

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.

Calculated field in a pivot table?
 

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.



Ashish Mathur wrote:

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
and explain the problem very clearly.

--
Regards,

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

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

--

Dave Peterson