|
Finding Duplicate Values
Here's how you find duplicate values in your dataset with Drill-Down Tally.
Only add field(s) to the Field Description rows under the Report Definition tab that you want to find duplicates with.
The first Field Description will be shown as a "Group". If you need more fields, add these with ShowAs type "Group Add"
You can add any number of fields as details that will help identify the record(s) in question.
Add the last Field Description with the name of first Group you entered and show it as a Count in the ShowAs column.
Now change the Sort Order column to Descending on the Count field description row. This would make all the counts greater than one move to the top of the list.
You can goto the Totals Filter tab and only show those records that have a count greater than one. On the first row use the pulldown box to show a list of calculations. It should show you one count calculation. Select it, then choose Greater Than for the operator and 1 in the value column. This should only filter for those that are duplicates now.
There is an example report that comes with Drill-Down Tally called Sample Finding Duplicate Values that illustrates this functionality.
|
