Show the value of previous week if current week is empty

[Loed]

Hi,

Is it possible to show the value of previous line or previous week if current line/week is empty?

So column L is the product of COLUMN I and COLUMN K. But what I wanted to achieve is similar to COLUMN Q wherein if current line is empty, it should display the previous line with value.

Is this possible in query designer or even in backend or in hana view?

Thank you.

Loed

[rathy_moorthy2]

It is very much possible in backend transformation. not sure what is the backend flow. you can check and decide where to incorporate it

Regards,

Rathy