Please help me to create the charts with the following requirement.
Input Sample Data:
| Country | YearMonth | YearWeek | Stock |
| America | 2013P07 | 2013W30 | 52 |
| America | 2013P07 | 2013W31 | 63 |
| America | 2013P08 | 2013W32 | 24 |
| America | 2013P08 | 2013W33 | 15 |
| America | 2013P08 | 2013W34 | 89 |
| America | 2013P08 | 2013W35 | 17 |
| America | 2013P09 | 2013W36 | 68 |
| INDIA | 2013P07 | 2013W30 | 100 |
| INDIA | 2013P07 | 2013W31 | 54 |
| INDIA | 2013P08 | 2013W32 | 87 |
| INDIA | 2013P08 | 2013W33 | 53 |
| INDIA | 2013P08 | 2013W34 | 62 |
| INDIA | 2013P08 | 2013W35 | 300 |
| INDIA | 2013P09 | 2013W36 | 80 |
Requirement 1:
To show the Stock value of Last/Max Week of the Previous Month in corresponding YearMonth. For example, the value of Stock of 2013W30 should be shown against 2013P08.
Chart 1 :
| YearMonth | Sum of stock of Previous Month's Last Week |
| 2013P07 | |
| 2013P08 | 152 |
| 2013P09 | 317 |
Requirement 2:
To show the Stock value of the Last/Max Week of the Previous Month for the curent Month ie last Week of Current Month - 1
Chart 2:
| Country | Sum of stock of Previous Month's Last Week |
| America | 17 |
| INDIA | 300 |
