Forum Discussion

KristinStubbs's avatar
KristinStubbs
Qrew Trainee
28 days ago

Unduplicated people summary report

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!

3 Replies

  • 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

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