I can’t figure out how to summarize a count of unique records across a grouping, either with a rollup or formula or even with a pivot table.
I’ve created a sample base here with creator permissions.
On the Interests tab, you’ll see the Categories I’m looking to count unique People across. Each of the groups should have 4 unique People. How do get that to show up somewhere?
Thanks!