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.
|