Are the sheets linked in a join in the data connection or are they blended (ie as two data sources, one with an orange tick mark and one with a blue one) ?
If linked... have you linked using a left join and if so which sheet is on the left?
If blended, which sheet has the orange tick mark and which has the blue one? Are you displaying the sales data directly or are you using a calculation?
I figured out how to do it. See how "SPEC" is on the left and "Territory Tier" is on the right? Just switch them and keep the same join. Works like a charm.