Reports - Multi-Select Fields

Some lookup fields allow selecting multiple values by holding the Ctrl or Cmd key and clicking.

Reports display these fields as a comma separated list of values in one 'cell' in the data table.

For example, if two values were selected for Senior Characteristics, the report row for a case would look like this:

What about a count of the individual values selected?

• Some multi-select fields have a corresponding "one row per value" subtable.
• Manually: Filter on the column, select one of the values, then run the report to get a count. Rinse and repeat with the next value, etc.
• Create a Lookup Transform Index to pivot the values into separate columns.