I have a list of items and they are grouped via a certain classification depending on a column.

How can I get that particular number of total items so I can use it on a status list/kpi?


2 Answers 2


If I understood your question correctly, this article would answer your question.

Basically you enable the group footers in order to display the "Count" of each group. Then you can modify XSL to fine tune the "Count" to how ever you wish it to be.

  • Thanks Jussi. Can this be applied to my query here: sharepoint.stackexchange.com/questions/27824/…. Basically I have two lists, Projects and Milestones. Each item in Projects list will have a set of Milestones (user created) and they should be viewed on a separate page like this: Project Details Project Description Lead: Members
    – chapnorman
    Commented Jan 31, 2012 at 7:48

A Status list (or KPI list) cannot count the items of one "group". However, it can count the items that are shown in a certain view. I sugest you create a new view for every value of the column that you group by.

Example: You group your task list by priority. Your priority column has the values "low", "normal", "high" and "critial". So you create the four views ("low", "normal", "high" and "critial"). After that you create your KPIs and use the new views to count the tasks with that priority

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.