how to get maximum of another column for a grouped column

Brass Contributor


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.





0 Replies