Hello,
I have table with different periods, Revenue and service IDs. I am trying to show the Revenue from the last period where it is not 0 for each service ID but in a summary table - therefore Previous() function does not work for me.
I tried with formula =Max([Period] where ([Revenue]<>0)) in([Service ID]) to flag the period but once the service ID is not available in the summary table the formula is not working.
So I am trying to show the results in green from the RAW DATA into Summary.

I am using SAP BI 4.2.
Can you please help me or give me any suggestions how to do it.
Thank you!