Issue on Power Pivot/Query Automatically Merge Duplicate Data

[tksnota]

Hi,

Is there a way to address the above issue because the sum of the pivot table and the original sheet is always different?

//NT

 

[RoryA]

1. I'd use Power Query.
2. I don't know what you mean by that.