Pivot Issue with Sums

Originally Posted by JosephP

Does a simple sum of the source data formula column produce the correct total? I reckon it probably won't.

Problem is I don't know the correct answer, so I can't compare.

The sum of all matches exceeds the number of users on the shorter list though.