Report - show duplicates

cgedney · ‎10-25-2022

I have built a table and I have two columns (Application (Reference to application table) and (User Access (Reference to a user table)). I have a couple other columns in this table, but I am only worried about these two. What I need to be able to do is build a report that shows only the duplicate records where these two columns are the same.

Example:

MyTable consists of columns app, useraccess, pizza and pie.

MyTable

row app useraccess pizza pie

------- ------------ ------------------ ------------ -------

1 app1 useracc1 pizza1 pie1

2 app2 useracc1 pizza3 pie2

3 app1 useracc1 pizza4 pie3

4 app3 useracc2 pizza 1 pie2

I want to build a report in which rows 1 and 3 are displayed. I cannot figure out how to get the report to do this.

Thank you, Charles

mattystern · ‎10-25-2022

Hi cgedney,

Not really sure how to do this in a listed view, but if you put this into a chart, you could use "Additional Group by" to achieve something like this:

Click "Additional group by" on your table"

Set to interested fields

Group by one and stack by the other

Result:

You can then click the bar to get the list view of this once the report is saved.

Let me know if this helps!

-Matt

View solution in original post

jjimenef · ‎10-18-2023

Thanks @mattystern I'm going to try that