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:
Let's say I have the following:
FIELD1 | FIELD2 | FIELD3 | FIELD4
Option1 | Option1 | Option2 | Option 2
blank | Option2 | blank | blank
The current summary is:
But what I want is:
How can I get this summary? Appreciate any help!