I have data in a table that I'm trying to count the number of times a word occurs and chart those. The date looks like this
Managed Services
Deployment Services;#Managed Services;#RFP
Deployment Services
Fulfillment Services
Deployment Services;#Fulfillment Services
Fulfillment Services
Fulfillment Services
Fulfillment Services
Fulfillment Services
Healthcare;#Professional Services
If I chart using
if(WildMatch([Group Assignment],'*Fulfillment*'),[Group Assignment])
It gives me a column for each unique entry that contains the word Fulfillment, what i'm trying to get to is a single column that shows me a count of every entry that contains the word Fulfillment instead of splitting them out.
