I guess you are right. I have tried and option sets couldn’t easily handle this scenario. [It handles, see the message above]
I could do it with a custom data type though. See the demo below:
I have created a data type for it:
Added the built-in values:
And in the calculation, you have to find the values of each selected in the multi-dropdown:
The format as text to apply some calculation to each element of the dropdown:
And when you are getting the value of a sports, you do the search for:
I hope this is clear 
Here is the editor if this is what you need and you want to check details: Test for Forum 12 | Bubble Editor