I’ve had a look but can’t find a simple answer to grouping items when those items come from a multi select list.
I have a table of different Scenarios and the multiple Services that apply to each. I want to be able to group each table and get the total cost for each scenario.
This works if it only applies to a singular scenario, but groups scenarios together if a service can apply to more than one. Ie I want the total cost for Car Servicing, Auto Sales and Test drive all split out individually in the Scenario Planning table, rather than have them grouped together (and as you can see, if I don’t multiselect the same items in the same order it treats it as a new group).
How can I do it so that each item is split? I’ve looked at Puzzle #10: Fruit combos · Solution and Grouping by a multi-select column | Coda Help Center but they didn’t answer my question.