Hi Experts,
I have the data let say
Table1:
| Date | CP |
| 1.01.2018 | 25 |
| 3.01.2018 | 12 |
| 17.01.2018 | 23 |
| 4.02.2018 | 43 |
| 13.02.2018 | 54 |
| 15.03.2018 | 13 |
| 16.04.2018 | 44 |
and I need the output
| Date | Current CP (Based on Max date in every month) | Previous CP (Just previous value to current CP) | Difference (Current CP - Previous CP) |
| 17.01.2018 | 23 | 12 | 11 |
| 13.02.2018 | 54 | 43 | 11 |
| 15.03.2018 | 13 | 54 | -41 |
| 16.04.2018 | 44 | 13 | 31 |
where i have to get Current CP based on Max date present in each month and the previous CP will be just previous value of Current CP value. How can I achieve this.
Please help if you can.
Thanks in advance.
