Forum Discussion
Solved
How to use multiselected values
I got lead data from Salesforce. A lead can be active in multiple industries. In Salesforce a multiselect field can be used to select all the common industies. I would like to show the quantity or p...
Hi, Oomsen ;
Please try it:
1. split column by dalimiter (";")
2.Select all separated columns then unpivot it.
3.create a measure to calculcate percentage.
Measure = DIVIDE(COUNT([IndustryMuti_]),CALCULATE(COUNT([IndustryMuti_]),ALL('Table')))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak thanks for the respond. I splitted the column.
The question now is how can i use the seperate columns to identify my leads by industry?