Weighted Average

[parpatra]

Month	Location	A	B
1/1/2010	A	10	15
1/1/2010	B	15	20
1/1/2010	C	20	25
2/1/2010	A	25	30
2/1/2010	B	30	35
2/1/2010	C	35	40
3/1/2010	A	40	45
3/1/2010	B	45	50
3/1/2010	C	50	55

Please help me with the expression.

MV=(A/B)*(365/Numberof days in month)

Avg=(MV1/31+MV2/28+MV3/31)/(31+28+31)

I am good with calculating MVs on chart but I need to show the avg in a pivot table for multiple selection of months.

Thanks in advance!!

[parpatra]

Ok..I have the answer now...It was around tweaking the expression!!