Business Area is a required column in my doc library. It's set up as "Checkboxes (allow multiple selections)". I have created several views, and in some of them I want the option to group by that column. However, it is not an option. Here's the reason I need that: In each view I am using the filter "Show items only when the following is true" for this column - but rather than using "is equal to" I need to use "contains" due to the multiple selections. That's fine, except that two of the Business Areas are Sales and Sales Associates. If I make it "contains Sales" it will bring up docs related to both, so I need to be able to group the display by Business Area to keep them separate. Can you tell me if there's a way to do what I need to do? Thanks!

1 Answer 1


I would make a separate view for each Business Area that is grouped by Sales Associates.

  • Thanks, I will try that. I appreciate the quick response. Sep 20, 2016 at 16:57
  • I'm still having trouble with this one. I already have a separate view for each Business Area, but it seems only certain columns are available in the "group by" list. Does it have anything to do with the fact that this is a different document library from the default Shared Documents? (i.e., it is one I created) Sep 20, 2016 at 18:25
  • 2
    The problem with group by is that you are only able to have an item listed once in the same view. So the multi-select choice column will not work. The views are the way to deal with that. Then make a link list of the views, or add them to the quick launch.
    – Jammin4CO
    Sep 22, 2016 at 15:20
  • That sounds right. I will work on that. Thanks for your help, Jammin4CO! Sep 26, 2016 at 19:50

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.