Skip to Content
0
Former Member
May 26, 2016 at 03:43 PM

Show duplicate values only on report

45 Views

I have a simple table with two columns. One column is a quote number and the other column is RFS (Request for Service)number.

I want my report to show only quotes that have more than one RFS attached. For example, a quote should only have one RFS associated with it, sometimes there are more than one. I need to filter the report down to only show me quotes with more than one RFS.

How can this be achieved?

This screenshot shows an example where there is one quote number with two RFS numbers.

I want the report to only show these.

Attachments

clip.png (8.0 kB)