I have a small table that builds from a much larger table. I.E. instead of the whole world, I just see the US portion of the business. When an amount is duplicated it ignores one of the values in the smaller table.
Table
Location A $5
Location B $20
Location C $20
2nd Table builds and it...