how to get maximum of another column for a grouped column

Masoud Sedighi 21

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 am using SharePoint 2013.

Xyza Xue_MSFT 27,266 Reputation points Microsoft Vendor

2022-12-26T05:49:27.397+00:00

Thank you for your question.
We are currently looking into this issue and will give you an update as soon as possible.
Thank you for your understanding and support.
Masoud Sedighi 21 Reputation points

2022-12-26T21:43:23.7+00:00

Hi, I put a comment please check and guide when you have time.

1 answer

Xyza Xue_MSFT 27,266 Reputation points Microsoft Vendor

2022-12-26T08:14:23.2+00:00

Hi @Masoud Sedighi ,
I read your requirement carefully, you want to auto populate maximum Rev value per Doc No in one sharepoint list column.
Unfortunately, per my knowledge, we can't achieve this function, we can't compare values in the same column, only with other columns. Thank you for your understanding and support.
Or you can create a view to sort them group by Doc No and maximum Rev, do you think this is feasible(As shown below)?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Masoud Sedighi 21 Reputation points

2022-12-26T20:46:23.003+00:00

Hi in this link (https://stackoverflow.com/questions/516073/max-query-using-caml) I have found something about maximum value, but my problem is,

that below code seems find the maximum value of column in the whole list not for each unique Doc No

do not know in which web part I have to copy that and how.

can I use below code in the calculated column in SharePoint. Thanks, in Advanced for any guide.
var maxValue; try { using (SPSite objSite = new SPSite(sSiteUrl)) { using (SPWeb objWeb = objSite.OpenWeb()) { SPList objList = objWeb.Lists[sListName]; SPQuery objQuery = new SPQuery(); objQuery.Query = "<OrderBy><FieldRef Name='ColumnName' Ascending='False' /></OrderBy><RowLimit>1</RowLimit>"; objQuery.Folder = objList.RootFolder; // Execute the query against the list SPListItemCollection colItems = objList.GetItems(objQuery); if (colItems.Count > 0) { maxValue = (<Insert Appropriate Cast>) colItems[0]; } } } } catch (Exception ex) { ... } return maxValue;

Xyza Xue_MSFT 27,266 Reputation points Microsoft Vendor

2022-12-27T03:01:25.433+00:00

Hi @Masoud Sedighi ,
Unfortunately, We cannot find the maximum value for each unique Doc No(cannot automatically identify every Doc No), and this code cannot be placed in the calculated column, it is used for powershell or csom.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Masoud Sedighi 21 Reputation points

2022-12-27T05:26:55.02+00:00

Thanks, with using OOTB web parts like (HCWP, CQWP, ...) can i use similar code for solving my problem?

actually, I am thinking about 1 scenario, but I do not know is possible and how?

using something like sub query for adding new Column to my list.
I read somewhere in the.NET with using LINQ is possible, but I do not know how and in which web part I have to use LINQ?

-

Xyza Xue_MSFT 27,266 Reputation points Microsoft Vendor

2022-12-28T10:05:51.783+00:00

Hi @Masoud Sedighi ,
I helped you consult a professional, unfortunately, there is no OOTB web parts similar code to solve your problem.

Xyza Xue_MSFT 27,266 Reputation points Microsoft Vendor

2022-12-30T09:16:50.057+00:00

Hi @Masoud Sedighi ,
I’m checking how the things are going on about this issue. Whether the answer helps you?
If there is any problem with this issue, feel free to let me know.

Xyza Xue_MSFT 27,266 Reputation points Microsoft Vendor

2023-01-03T02:20:10.767+00:00

Hi @Masoud Sedighi ,
Did my response answer your question? If I misunderstand something, please let me know!
If there is any other assistance i can provide, please feel free to let me know, i will do our best to help you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

how to get maximum of another column for a grouped column

1 answer

Your answer