Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Unique Lookup values across a grouping

Topic Labels: Formulas
712 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Trudy_Lei
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0