Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have this data
Month | Value | |
---|---|---|
201205 | 200 | |
201204 | 100 | |
201203 | 50 | |
201202 | 100 |
I want manipulate the data and pass to one row, like this
Month | Current | Month-1 | Month-2 |
---|---|---|---|
201205 | 200 | 100 | 50 |
201204 | 100 | 50 | 100 |
201203 | 50 | 100 | 0 |
The idea is have the current value and the last 4 months.
¿Any suggestions?
Thanks in advance
Julian
Something like this would not be hard.
I think this is what you did imply
Thanks for help me Nick. Regards
Thanks for help me. Regards