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!
Qrew LegendI 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
That worked. Thanks Mark!
Also, I would suggest not using "contains" as it can cause false positives. Always best to use an exact match IMHO.
