Hi,
I am trying to achieve the goal on the 3rd table using the 1st and 2nd table in PowerPivot. Hope I could get help from you.
Table 1
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| New Well Count of Field 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 |
Table 2
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Typical Oil Well Production Curve(barrels of oil per month) | 500 | 480 | 460 | 450 | 433 | 418 | 403 | 388 |
The goal I want:
| | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Field 1 | 0 | 0 | 500*1 | 480*1 | 460*1 | 450*1+500*2 | 433*1+480*2 | 418*1+460*2 |
Thank you very much!
kayyeah11
