Calculated field in a pivot table?

D

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

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top