Hi everyone,
I have this example:
| | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| % e-Sales | 20% | 10% | 10% | 40% | 60% | null | null |
| % e-Orders | 3% | 5% | 6% | 2% | null | 7% | null |
| % Other e's | 40% | 35% | 15% | null | null | null | null |
I want to take the last available value and change it to null values.
I want this final result, :
| | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| % e-Sales | 20% | 10% | 10% | 40% | 60% | 60% | 60% |
| % e-Orders | 3% | 5% | 6% | 2% | 2% | 7% | 7% |
| % Other e's | 40% | 35% | 15% | 15% | 15% | 15% | 15% |
How could i create this?
Thanks,
