Skip to main content

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!

Hi ​@stevej

The only way I found to handle this is a Data Design that either uses transforms to filter individual values and then does a union of each branch obtained, or a Pivot table that already does the grouping and counting in one step. 

The pivot table won’t give you the possibility of drilldown while the Transform+Union does. 


A little bit slicker solution is to store each option as a new row in a different table. Then bring in the that data and cartesian merge with your data and then do a filter where if multi select contains the row value in the new object.


Reply