Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See attached qvw