Calculation Problem

[burakkaragoz]

Hello,
As you can see in the table below, there are multiplexed rows.
The result I want to show and calculate here is the row with the maximum value.

I will be grateful if you could help me.

[Arul]

@burakkaragoz ,

Can you share some more sample and expected output in detail?

Thanks,

Arul

[burakkaragoz]

It should show the following result as output.