Skip to main content
Question

Unduplicated people summary report

  • Jun 27, 2025 4:05 PM UTC
  • 0 replies
  • 213 views

Forum|alt.badge.img+2

I built this summary report and need help filtering out duplicated clients. This report is built on the "Case Clients" table that is the many-to-many table connecting "People" to "Cases". I need this report to only show unduplicated people within each column. I have not used 

Help!

MarkShnierYou
Forum|alt.badge.img+24

I have not tested, but try changing the summarize what setup to be [people name], and use the summary method to be Distinct  Count.  Please post back and let me know if that works.  

https://helpv2.quickbase.com/hc/en-us/articles/4570321780372-Create-a-summary-field


Forum|alt.badge.img
  • Observing
  • Jun 30, 2025 7:48 PM UTC

Also, I would suggest not using "contains" as it can cause false positives.  Always best to use an exact match IMHO.