SharePoint List view Group sum instead of count

2015-11-08

Question

_{Sunday, November 8, 2015 9:13 AM}

list field A , Name

List field B, Price

When i group the list view by name, its showing count of item under this, can i show the sum of price .

All replies (7)

_{Tuesday, November 24, 2015 9:11 AM ✅Answered}

Hi,

Yes, the “Sum” functionality won’t apply to Choice column.

A workaround can be like this:

1. Create an extra Number column;

2. Create a SharePoint Designer workflow, it will run when there is item created or updated. There is OOTB workflow actions in SharePoint Designer can be used to get value of the Choice column and assign to the Number column;

3. Apply the “Sum” to this extra Number column, you will get the result you want.

The links below will provide more information about SharePoint Designer workflow:

http://office.microsoft.com/en-001/sharepoint-designer-help/workflow-actions-in-sharepoint-designer-2010-a-quick-reference-guide-HA010376961.aspx

http://office.microsoft.com/en-001/sharepoint-designer-help/introduction-to-designing-and-customizing-workflows-HA101859249.aspx

Workflow actions in SharePoint Designer 2010: A quick reference guide

http://office.microsoft.com/en-001/sharepoint-designer-help/workflow-actions-in-sharepoint-designer-2010-a-quick-reference-guide-HA010376961.aspx

Thanks

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Monday, November 9, 2015 3:13 AM}

Hi,

When you create view, did you set up Totals?

It should be under Group By section, you can choose Price column to display sum.

Thank you

_{Monday, November 9, 2015 7:50 AM}

Agree with Ali. Try using the "Totals" section UNDER "Group By". You can use the drop menus to change what you want.

If this is helpful please mark it so. Also if this solved your problem mark as answer.

_{Friday, November 13, 2015 9:09 AM}

Hi,

Any update?

Thank you

_{Thursday, November 19, 2015 12:07 PM}

In Total, its only showing "Count", which can only give the number of items not sum of any value...

_{Tuesday, November 24, 2015 6:44 AM}

Hi,

In the “Totals” section of the list view settings page, there is a “Sum” which can be used to sum up values in a “Number” column(in my list, it is “Price”):

The outcome:

Thanks

_{Tuesday, November 24, 2015 7:17 AM}

Hi, Sorry to mentioned this in my initial question, that i am using Choice column instead of number, in number we can easy get the sum but i need to do it in choice column...

Share via

SharePoint List view Group sum instead of count

Question

All replies (7)

Additional resources