Skip to main content
Question

Unduplicated people summary report

  • June 27, 2025
  • 0 replies
  • 189 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+22
    • MarkShnierYou
    • Quickbase Alumni
    • June 30, 2025

    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

    Mark Shnier. Your Quickbase Coach
      Forum|alt.badge.img
      • JrossKuhn
      • Quickbase Alumni
      • June 30, 2025

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

        Terms & ConditionsAccessibility statement