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

  • Question

  • Is there an option to calculate the total count of items in a column using Calculated columns?
    Thursday, June 23, 2016 1:09 AM

Answers

All replies

  • 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 3:54 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.




    • Edited by sk2014 Thursday, June 23, 2016 6:35 AM
    Thursday, June 23, 2016 6:32 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.

    Thursday, June 23, 2016 6:38 AM
  • 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


    • Edited by Tina YiMVP Thursday, June 23, 2016 8:46 AM
    • Proposed as answer by croute1 Thursday, June 23, 2016 2:41 PM
    • Marked as answer by Sara Fan Tuesday, July 5, 2016 12:33 AM
    Thursday, June 23, 2016 8:41 AM