SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question

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.

share|improve this answer
Thanks Jussi. Can this be applied to my query here:…. 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 Jan 31 '12 at 7:48
@Jussi Thanks for the link. It solves my issue. – neo269 Feb 3 '12 at 12:14

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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