Skip to Content
0
Sep 05, 2023 at 09:50 AM

Revenue from Previous Period in Summary table

60 Views

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.

image.png

I am using SAP BI 4.2.

Can you please help me or give me any suggestions how to do it.

Thank you!

Attachments

image.png (66.3 kB)