I have a table of account numbers with the account number as the primary field and I created a view that groups by the account number. I’m trying to detect duplicate account numbers and ideally I would like to be able to filter the grouped account numbers where the count is greater than one.
Being able to sort by the count would be another option. If I could sort by the count in descending order, then the duplicate account numbers would be at the top of the list.
This same functionality would be great for other columns besides the grouped by columns that can be aggregated.