SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

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 apologize if the answer to this is obvious, I'm just completely new to SharePoint and need at least a pointer in the right direction.

I have a list with a "Choice" field. I've used InfoPath to modify the form input to use a multiple selection list box. The resulting list items look something like this:

    Title              Choices
     alice              foo, bar
     bob                baz, bar
     charlie            bip, baz, foo

What I want is a way to get the total instances of each choice within the entire list: e.g., how many "foo" in the entire list, how many "baz", etc. So far I haven't been able to figure out how to do that. Any help or hints would be greatly appreciated!

share|improve this question
Are you building a custom webpart? – sssreddy Apr 19 '12 at 19:40
If you're open to 3rd party solution then PivotPoint will do this - (usual disclaimer, its my own companies product) – Ryan Apr 20 '12 at 9:52
@sssreddy No, not a custom webpart. – sjs Apr 20 '12 at 12:18
@Ryan, unfortunately my access is limited to using the current install as-is, but thank you for the tip! So am I correct in assuming there is not a simple solution for this that I'm just overlooking? – sjs Apr 20 '12 at 12:18
OOTB - Afraid not. If you were using single choice fields you could get most of the way there with a view grouped on the Choice field, but not with multi choice - you're going to have to develop something, either web part or client object model javascript (2010) – Ryan Apr 20 '12 at 13:28

Your Answer


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

Browse other questions tagged or ask your own question.