Fill empty cells with previous values in Webi

[Former Member]

Hello,

I have a query with the following dimensions:"Customer", "Status" (which can be "D", "E" etc.), "Date From" and "Date To". I also have a separate query with a "Date" dimension containing every day in the calendar.

What I'd like to do is display the Status in a cross-table with the Customer on the left and the continuous Date on the top, like this:

(This is how this was done:

=If(([Date From] <= [Date]) And ([Date To] >=  [Date])) Then [Status]  )

Except I'd like the empty Status cells to be filled with the value of the previously filled cell (for example an "E" on 10. - 12. August)

I don't have access to the Universe, so I would appreciate a Webi-only solution.

Thanks for your help!

Edit: Using the Previous() function only fills in the first empty cell (e.g. "10.08.16"), the following cells remain empty (e.g. 11.08, 12.08)

[sateesh_kumar1]

Hi,

try below

=If IsNull([Status]) Then  Previous(Self) Else [Status]

Thanks

[Former Member]

Hello Sateesh, This only fills in the first empty field. Please see the edit in my post (last sentence)