Display All Duplicate Records

[tamilarasu]

Hi,

Is there any way to display all the duplicate records in a chart. I have duplicate values in field %CustProd and I need to show the both file names and %CustProd like below. I have to do this in expression. Can anyone guide me.

Attached sample file also

Thank you in advance.

[rwunderlich · Accepted solution]

You should be able to display the duplicates with a calculated dimension of:

=if(

aggr(Count(%CustProd)>1,%CustProd)

,%CustProd)

and a second Dimension of Filename. Uncheck "suppress zero values" on Presentation. See attached.

-Rob

http://masterssummit.com

http://robwunderlich.com

[tamilarasu]

ROB