I am using SharePoint Modern. Can I display only sum value of selected column from List on Page? I do not want to show all the List Item. Best is to show as a textbox in Page
4
-
There is no SharePoint out of the box web part to achieve this.– Ganesh Sanap - MVPJul 21, 2021 at 7:48
-
Any workaround available on this?– JamesJul 21, 2021 at 9:32
-
Create simple app using Power Apps to show the count/sum OR develop simple SPFx web part (This will help for longer run as you can make if configurable to select list & list columns from web part properties).– Ganesh Sanap - MVPJul 21, 2021 at 10:14
-
I am quite new to SharePoint. As far as I can see from my SharePoint, I dont see any access to SPFx or SharePoint Designer, though I am admin of the site. May I ask, How can I achieve that?– JamesJul 21, 2021 at 22:53
Add a comment
|
1 Answer
If the selected column is a number column, you could use OOTB sum function.
As a workaround, you could open the list in the excel, then calculate in the excel.
Reference:
https://www.spguides.com/open-sharepoint-list-in-excel/
Update:
Display column sum in the other page by using scripts. https://stackoverflow.com/questions/58890560/sum-of-sharepoint-list-items-in-particular-field https://social.msdn.microsoft.com/Forums/office/en-US/3ef7d887-9fa3-416c-9350-520bb2b1df4a/camlquery-to-display-calculated-column-total?forum=sharepointdevelopment
answered Jul 23, 2021 at 10:25
-
Thanks for the advice. I am looking for just extract the sum value, so that I can display the value in a label or box form (part of dashboard) in the modern Page.– JamesJul 24, 2021 at 2:12
-
-
-
-