Compute Average in Pivot Table

[howard]

I have several branches in a pivot table showing the total profit in a Column and the number of items sold for a particular item in another column


I would like to know how to set up a formula to calculate the average Profit on the pivot table for each branch


see sample data below

Book1
	A	B	C	D	E	F
1		Branch
2		BR1		BR2
3	Description	Profit	No. of Items Sold	Profit	No. of Items Sold
4	Shirt Manhattan Blue 36	5.15	1	5.15	1
5	Shirt Manhattan Blue 37	7.25	3	7.25	3
6	Shirt Manhattan Blue 38	6.5	5	6.5	5
7	Shirt Manhattan White 40			5.75	2
8
9
Sheet1