Multi-level pivot table reports can show incorrect total count values when aggregating based on a Count Distinct and a Reference field. - Support and Troubleshooting

Multi-level pivot table reports can show incorrect total count values when aggregating based on a Count Distinct and a Reference field. Issue  Symptoms Multi-level pivot table reports can show incorrect total count values when aggregating based on a Count Distinct and a Reference field.

Release All Releases

Cause This can occur when the aggregation is based on a Count Distinct and a Reference field as the platform applies the Count Distinct on the Reference field's display value. If there are multiple records for the Reference field with the same Display value, the aggregated count will then show a smaller number than the actual count of distinct records. Resolution

Modify the Display values of the Reference field so that they are unique.