Forum Discussion
How to get different combinations count?
I have a SharePoint "Country" Dropdown multiselect column, Country column values are
A
B
C
D
E
F
G
The user can select multiple values the record values like below
1) A,B,C
2)A,C,B,D,F
3)A,B,C,D,E,G
4)A,B,C
I want to take the different combination and their their count
So we have A,B,C combination occure 2 times: Count is 2
3 Replies
So typically you would split that out in Power Query and unpivot.
No, I don't want to split,
I Just wanted to get the count of Unique combination.
In each record which combination user has selected and the count of that combinationpresent in List (Table)
