When I generate a pie chart from this the total result is wrong because pie just sum the value of each line. When the correct is apply Distinct([Atendente]) without grouping to show the realy total without repetitions.
If I want the total of agents that have attended I can NOT just sum the result of each department. The correct is Distinct([agent]) without grouping like that:
So, the Pie chart just sum the value of each group not obeying the aggregation function Distinct([agent]) - I have just 3 agents (Mary, Mark and Jhon) and not 5
@trialsin No, it's the other way around. Pivot Table is incorrect. It should display 5.
If you want number of distinct agents, then don't group by agent, or just use count if you group.