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