Aggregate Sum function does not match

[Ericus]

Ok, so I've encountered a problem I can't seem to figure out the reason as to why it is happening.  My summation in the pivot table does not equal the total of the availible data points. Sum([Belopp Brutto]) should aggragete over all facilities 9260311015, but it gets a higher value. It is accurate for several other facilities, but not some have shouldn't so I guess my question is what am I missing?

[albertovarela · Accepted solution]

Something tells me you have a couple of duplicated records. Create a table with Dim: Anlaggning and measure: Count(Anlaggning).  Select that same value from your screenshot and I bet you'll get a count > 3.  I hope this helps