Showing results for 
Search instead for 
Did you mean: 

Show duplicate values only on report

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

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
0 Kudos

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

Thanks Amit!

Answers (0)