I have a list of text fields containing some duplicates, and I would like to show it in a repeating group with the count of duplicates next to each text field, and then sort it in a descending order of the number of duplicates for each item
For instance:
California
California
Hawaii
California
New York
New York
New York
California
Should become:
California 4
New York 3
Hawaii 1
I was able to display the list in a repeating group by showing the unique items, and the count for each, but I am not able to sort the repeating group by the number of duplicates for each item as it is calculated in real time.
I don’t want to create a new data type for the {State, Count} pair and populate it with that list.
Is there any other way to do it?
Thanks in advance!