Skip to Content
0
Apr 19, 2020 at 02:09 PM

Repeat data for missing months in HANA calculation view

264 Views

I need to adjust my calculation view to obtain below results

Repeat previous month record for current month, If its missing for current month.

Example- Table data i have

Month Material Plant Value Qty Price

201901 M001 P001 500 10 50

201904 M001 P001 700 15 47

201910 M001 P001 900 12 75

Output I need -

Month Material Plant Value Qty Price

201901 M001 P001 500 10 50

201902 M001 P001 500 10 50

201903 M001 P001 500 10 50

201904 M001 P001 700 15 47

201905 M001 P001 700 15 47

201906 M001 P001 700 15 47

201907 M001 P001 700 15 47

201908 M001 P001 700 15 47

201909 M001 P001 700 15 47

201910 M001 P001 900 12 75

201911 M001 P001 900 12 75

201912 M001 P001 900 12 75

How can this be achieved using HANA CV ?

Thanks for your help !