Forum Discussion

KristinStubbs's avatar
KristinStubbs
Qrew Member
4 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!

reports

1 Reply

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    8 hours ago

    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