logic help to calculate last & max value.

[lalitkgehlot89]

Hi,

In current scenario, I want to calculate Four value in given data.

1) Unit1  HP Cylinder Efficiency MAX Date, Max Block value with date and BlockNo

2) Unit2   HP Cylinder Efficiency MAX Date, Max Block value with date and BlockNo

3)Unit1 HP Cylinder Efficiency Max Date, Max Value With with date and BlockNo

4) Unit2  HP Cylinder Efficiency Max Date, Max Value With with date and BlockNo