add the value of the column with the previous value that does not exist

[cristianj23a]

Hi.

I have a table showing the person and the date.

In the highlighted image it is displayed that a person who has as "N ° ASISTENTE" 885 and
"ZOSTB_Elemento_PEP" PU18T3G13111031 and"ZOSTB_NumPers" 1552, until 08/07/2018; therefore, those days are added to the table.

Using the following code.

It gives me as a result:

In the end, that is the table I want, however, if I delete the highlighted filter that was in the code, it will return to this as in the first table.

Please help me with this topic.
Attached that qvw and xls.
Greetings.

[Marcos_rv]

Good morning, I do not understand the reason why you would want to do that. I understand that using date ranges would be good, but in the case where you have more than one record for the same date, the same "N ° ASSISTANT and the same ZOSTB_NumPers, that should not work.

[cristianj23a]

Hi Marcos.

If you notice in the image, the ZOTB_ELEMENTO_PEP change when day 4 arrives, but I need you to show me on day 2 and 3 with the same ZOTB_ELEMENTO_PEP.

regards