Pivot - Amount divided by Count

  • Thread starter Thread starter sanshah01
  • Start date Start date
S

sanshah01

Hi,

I have a pivot with Sales information. The data has multiple columns by
various product category. I have added a count column next to each
product column representing the dollar amount.

Is there a way in Pivot to get a calculated field of Total amount /
Count for each product to arrive at Average value per deal.

Excel does not allow me to use Calculated Item to get the average
number.

Any suggestion is welcome.

Regards
Sandip.
 
If you are unable to create the formula in the pivot table, have yo
considered placing it in a row next to the table? Just a thought...
 
You could add another copy of the Sales field to the data area, and set
it to summarize by Average.
 

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

Similar Threads

Pivot Table question: Creating a new field that calculates thedivision of one data field by another 4
How to ignore a column of numbers in Grand Total for rows 1
Average of Subtotals in Pivot Table 0
Excel 2007 issue...Urgent 1
Time phase sales based on award dollar amount. 2
pivot table calculated field 1
Pivot - Calculated field 1
Pivot Table Grand Total Issue 3

Back
Top