Pivot - Amount divided by Count

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

SHMUNCY

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

Debra Dalgleish

You could add another copy of the Sales field to the data area, and set
it to summarize by Average.
 
Top