Group by in front end

[#1]

I am attaching a simple QVW file and my issue.....

I loaded inline

ID  Name  Value

1    A         10

1    A          20

1    B         30

I want to get max of value for ID and Name

1   A   20

1    B   30

[#2]

Sorry I got it......I made it complex myself......