Skip to Content
0
Dec 21, 2022 at 11:58 AM

Data Action Script Logic MAX

115 Views

Hi everyone,

I need help with finding maximum value for each row that is uniquely defined by these dimensions: From Razdeo to Konto 3. This logic needs to work in a way that for each mentioned row we need to go through each month of Date dimension and find which month has maximum measure value.

image.png

I tried writing FOREACH loop, but it doesn`t go through each month for each row as it should. Does someone have any idea how to achieve that logic through foreach? I read on SAP Help how foreach works, but still can`t figure this out.

image.png

Best regards,

Marija

Attachments

image.png (59.3 kB)
image.png (15.7 kB)