Group by only CERTAIN values

Topic Labels: Base design Data
413 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Is there a way to group values by only a select number of groups? 

I have a cell title "groups" where we dump in all records the various groups that we have in our base. i.e. Accelerator, Incubator, Advisory Board, Faculty, etc.. This means when I go to group one section, in this case the advisory board, the group gets split into multiple groups. Those with just "Advisory Board," those with "Advisory Board and Incubator" etc.

Is it possible to just group these by "Advisory Board" and "Faculty" and ignore all the other "Groups" that are present?


1 Reply 1
11 - Venus
11 - Venus

One idea is to group them by conditional branching in a formular field.

SWITCH({Group Name},
  "Advisory Board",{Group Name},
  "Incubator",{Group Name},

Group by this field.