There are several ways you could tackle this. The best way also takes the most work, and requires some data prep. Another way is to create several calculated fields and get the count for each. I don't have a ton of time to go into depth right now, but if you send a sample workbook I might be able to take a look.
1. Split the field in the Data Source Tab (right-click on the field and select Split)
2. Export all the underlying data
3. Connect to the exported data
4. Pivot the NEW data
5. Count the instances
1. Create a Calculation for CL1 called Client: COUNT(CONTAINS([PASSON],"CL1"))
2. Repeat for each category
3. Use Measure Names and Measure Values to build your view as desired.
@Nicholas Hara, thank you for the reply. I am getting data from oracle database and I am not aware how to split data process. I can provide you the data spreadsheet if you still required. I will try using count function in calculation. Thank you again.
I am getting data from oracle database and I am not aware how to split data process.
You had me wondering if its possible to use Split functionality with Oracle, just tried, and it works fine.
When you first connect to the data, on the required field, press the drop down arrow, as highlighted below
Thank you Mark.