Hello to all you excel Gods,

I have created a pivot table to show the total gross and average gross of
sold items. I have included the amount of stock items and on order items.

My problem is that my average gross is showing for a total of the sold
new,sold used , stock and on order items as my worksheet has a seperate
column for sold, stock and on order.

Therefore I thought "Calculated fields" would work. I does for one instance
but I can't seem to have more than one calculated field show on the pivot
table.

I wanted to show a field for the total sold new and used stock then another
showing the total gross divided by a total of new and used sold.

Sorry for the essay.

Gross New Sold Used Sold Stock On order
5721.82 7 0 2 0
10569.21 29 3 3 9

Average gross I want to be Gross divided by New sold plus Used sold.

Thanks in advance