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.
