Hi All,
Looking for an answer to count how many are duplicates base on the date
that will show on the pivot table.
Desired output
Thank you for responding,
I got confused with ‘count’ and duplicates, I’m looking for a way to only pickup
if there is a duplicate in a column.
Here is an example
The 2nd column “Missing”,“Reconciled” and “Duplicates” are calculated fields that are checking another column let say “Breed”
It will only counts how many are a duplicate.
Here It will show up on the “Duplicate row” ‘1’
By doing ‘count’ you’ll effectively sum the number of times each entry appears thus counting duplicates. You could do this as a calculated field using: count({Breed}) or you can just use Breed in the Value field well. If you don’t want any zeros or nulls to appear you can filter those out on the chart.