Group function: multi-entries
I have a database where I want to use a multi-choice as grouping. The problem is that if an item has 2 or more choices it makes a separate group instead of adding the item into 2 groups.
Lets say I have the following 2 items with the following multi-choice answer as ingredients.
Meal pack A
Union
ChickenMeal pack B
Carrot
Union
And I want to group them on ingredients.
Current situation
Union, Chicken
Meal pack A
Union, carrot
Meal pack B
Optimal situation:
Union:
Meal pack A
Meal pack B
Chicken:
Meal pack A
Carrot:
Meal Pack B
16
votes
Roxstar
shared this idea