Remove Duplicates

[ADB1]

I am trying to remove some duplicates from a list report. The actual row isn't duplicate but a part number columns shows multiple instances of the same part number. I want to only take the first row where the part number is the same, therefore removing trailing duplicate part number records.

I have used the formula below to identify duplicates:

=If Previous(<Part Number>) = <Part Number> Then "Dup" Else <Part Number>

But after this has ran you are not able to filter on the variable.

Has anybody found a workaround to this problem?

THanks.

 

[bertdijks]

Try to identify which instance you want to select, for example with the first date (orderdate, changedate, etc)
=If (<date>) = (max(<date> in <partnumber>)) Then "Dup" Else <Part Number>

You will not be able to use this as a filterm because this is an agregation function. As a work-around you can adjust the formula:

<user_variable>=If (<date>) = (max(<date> in <partnumber>)) Then 1 Else 0
after this apply a ranking on partnumber, with top <user_variable> values

or use create an variable in the universe to identify the first row an apply a filter on this.

 

[sh4kil]

Can you not apply a break on the report using the part number?