Summary/Chart Data from Multi-Select Fields

This is possible ... just not easy. I just figured it out.. Heres how!

Create a multi-select.. mine has the options in between " "

Create a calculation and like the below, add all your selectable items 1 per line like below swapping out the content between the "" for yours.. The name of my multi-select is Tactics so replace that with the name of yours.. the )))) at the end must total the ((( you opened... No in your report create a group by your calculation, and report on the number in that group.... TAADAA!

IF(CONTAINS("Experiential",Tactics),"Experiential",

IF(CONTAINS("In Store Marketing",Tactics),"In Store Marketing",

IF(CONTAINS("Social",Tactics),"Social",

IF(CONTAINS("CCS, Production",Tactics),"CCS, Production",

IF(CONTAINS("Demo",Tactics),"Demo",

IF(CONTAINS("Loblaw Digital",Tactics),"Loblaw Digital",

IF(CONTAINS("Digital Screens",Tactics),"Digital Screens",

IF(CONTAINS("SDM Creative, Production",Tactics),"SDM Creative, Production",

IF(CONTAINS("Media",Tactics),"Media",

IF(CONTAINS("SDM Digital",Tactics)," SDM Digital",

IF(CONTAINS("Radio (In Store)",Tactics),"Radio (In Store)",Tactics)))))))))))