Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table calculated field | Excel Worksheet Functions | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table | Excel Worksheet Functions |