Show duplicate values only on report

[Former Member]

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.

[amitrathi239 · Accepted solution]

create one variable

Show/Hide=If(Count([Quote Number];All) In ([Quote Number])>1) Then "Show" Else "Hide"

Apply the filter on Show/Hide variable and select value Show.

[Former Member · Accepted solution]

Awesome! So simple, I was trying to make it harder than it was.

Thanks Amit!