I would like to do the following calculation with 2 fields (Date and Price)
e.g. Date Price
Date
Price
Average Price
Average of Average price
Jul-01
1
Aug-01
2
1.5
Sep-01
3
2
1.75
Oct-01
4
2.5
2
Nov-01
5
3
2.25
Dec-01
6
3.5
2.5
Jan-02
7
4
2.75
Feb-02
8
4.5
3
Mar-02
9
5
3.25
e.g. In Nov-01,
Average price = (1+2+3+4+5)/5 = 3
Average of Average price = (1.5+2+2.5+3)/4 = 2.25
My problem is that: I want one figure 3.25 (the yellow one). How can write the formula?
That is, instead of using a pivot table for so many row, I want to get the figure of 3.25 directly.
Date
Average of Average price
Mar-02
3.25
Any thought?
Or, it will be great if there is anyone can help to tell me:
In Script: How can I get the sum/avg/stdev of increasing time periods?
That, in Nov 01, I get the sum of price from the beginning up to Nov 01 only (Dec 01 data existing, but I don't want to include it or any data after that date)
