Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
ROB