Add "group by" view for multi-select columns to only show single values

In reporting, users can group by a column. Column types where multiple values may be associated with a constituent will group by the various, multiple combinations of those values. Some users do not want all of the combinations and instead want a single value grouping and only show a constituent in one of the grouping values instead of all. This idea would add a "group by" view option for multi-select type columns that list each value individually and not combinations.

Example:

• Constituent 1 is A, B, and C

• Constituent 2 is A and C

• Constituent 3 is A

• Constituent 4 is D

Current group by view option:

• Row A

  • Constituent 3

• Row A,C

  • Constituent 2

• Row, A,B,C

  • Constituent 1

• Row D

  • Constituent 4

New view option may display constituents in multiple rows (tbd) but would only count them in one:

• Row A

  • Constituent 1

  • Constituent 2

  • Constituent 3

• Row B

  • empty or Constituent 1

• Row C

  • empty or Constituent 2

• Row D

  • Constituent 4