how to get maximum of another column for a grouped column
Hello in my SharePoint list I have below columns and meta data: Doc No Rev Doc-0001 00 Doc-0001 01 Doc-0001 02 Doc-0002 00 Doc-0002 01 Now I want below to result in the view or query, that added another column that show maximum Rev for each Doc No Doc No Rev Maximum Rev Doc-0001 00 02 Doc-0001 01 02 Doc-0001 02 02 Doc-0002 00 01 Doc-0002 01 01 I read something about CAML in the NET, but I do not know how I have to use that for solving my problem. Regards, Masoud