how to get maximum of another column for a grouped column

Brass Contributor

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

 

0 Replies