I’m building an activity report based on activities submitted by our CSMs that include a dropdown list, where multiple items can be selected. I’d like to have the report show a count of submissions that count the number of individual dropdown items, not the combined amount of dropdown items. For example, I’d like it to show this:
Count of dropdown 1: ###
Count of dropdown 2: ###
Count of dropdown 3: ###
Instead, it’s showing this, which is too cluttered:
Count of dropdown 1: ###
Count of dropdown 1;dropdown 2: ###
Count of dropdown 1;dropdown 2;dropdown 3: ###
Count of dropdown 1;dropdown 3: ###
Count of dropdown 2: ###
Count of dropdown 2;dropdown 3: ###
Count of dropdown 3: ###
Is it possible to do this in the Report Builder? Thanks!
