I have a lookup field on my clients table that lets me know what type of service they received. This is a lookup from a multiselect (the client can get more than one type of service in a single session). I need a pie chart to show me how many clients received specific services. Is there a way to filter out only the categories that I want from the lookup field?
Ex:
Client----Service
Sam -----Zoom, Customization, Training
Ed ------- Training, Customization
I want a chart with only Customization and Training numbers