Calculated Column to show the total count of items in a column?

Question

_{Thursday, June 23, 2016 1:09 AM}

Is there an option to calculate the total count of items in a column using Calculated columns?

All replies (4)

_{Thursday, June 23, 2016 8:41 AM ✅Answered | 1 vote}

Hi

Maybe you can reference this thread, it can following this situation: List B can be added a calculated column which should be sum of all entries in List A that have the same name as in List B. And then you can use ListB to provide a summation and show the report or dashboard.

http://stackoverflow.com/questions/16295567/how-to-create-calculated-column-with-data-from-another-list

_{Thursday, June 23, 2016 3:54 AM}

Hi

Do you mean that you want to show total count of items in SharePoint 2013 list? If yes, please reference this article:

http://www.enjoysharepoint.com/Articles/Details/show-total-count-of-items-in-sharepoint-2013-list-21105.aspx

_{Thursday, June 23, 2016 6:32 AM}

Instead of calculated column, you can create a view for your custom list and set the sum of each column.

Select the view and expand the totals group, in that select the sum from drop down.

save the view and set the newly created view as default view.

_{Thursday, June 23, 2016 6:38 AM}

@sk2014 & Tina0327, thanks for responding. I`m aware of this view feature. But that would only show the data while viewing the respective list. We want the data to be displayed using calculated column, so later i can use the value part of the calc column and flashed on to our dashboard, in order to provide a summation.

Hope that clarifies.