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.

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.

Best regards,
Marija