I have a multi-select field and I'm trying to get a specific summary report and can't figure this out.
For my FIELD I have the following text options:
- Option 1
- Option 2
Let's say I have the following:
FIELD1 | FIELD2 | FIELD3 | FIELD4
Option1 | Option1 | Option2 | Option 2
blank | Option2 | blank | blank
The current summary is:
- Option1 = 1
- Option2 =2
- Option1;Option2 = 1
But what I want is:
- Option1 = 2
- Option2 = 3
How can I get this summary? Appreciate any help!