I have a simple pivottable in which I have used COUNT to figure out number of
stores per the data I have. I also have a total unit sales. I now want to
take the total units and divide by total stores to get units per store. What
it looks like it is doing is performing the division before it is summed, so
the units per store is the same as total units. I want it to calc after the
sum is done.

I have created two formulas and not seeing anything in Solve Order when I go
to this. What I have done to date is just set up a formula outside of the
pivot table and just do the division that way. The problem is is the table
changes, the formula may not be referring off to the correct cells (numbers)
anymore.

Any suggestions/directions would be greatly appreciated.

I am in Excel 2007.
--
Peter