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.