Dear clever excel people...
I have a problem with the average feature on Pivot table.
I am trying to get an average of the Average Sale price.
Input data :
Company A:
- total sales £ 60480
- Units sold 315
- unit price - £ 192
Company B:
- Total sales £ 1050
- units sold 5
- unit price - £ 210
For some when I ask the pivot table for an average i am getting £ 194.3076923
But when I calculate it I want - (overall sales)/(total quantity) = £ 192.28125
Where am I going wrong and what average is the pivot table pulling ?!!
This has been driving me mental - please help !!
thanks
Si
Bookmarks