Basic relashionships and Matrix visualization

[Anonymous]

Hi!!

I need help with something that seems quite basic, but i'm having some trouble.

I have two tables that have some similar columns: reseller, state and financial period.

One tells me how much my reseller should be paying me, the other is data from a system that tells me exactly how much they actually did pay.

I used the reseller column to create the relationship and when i try to add the state to the matrix, it does not work (because i'm using the state from one table, or the state from the other, so it can't filter).
How can i do this right?

Reseller	State	Value System 1	Financial Period
ABC	New York	3	01/Aug - 10/Aug
ABC	California	2	01/Aug - 10/Aug
ABC	Texas	7	01/Aug - 10/Aug
DEF	New York	1	01/Aug - 10/Aug
DEF	California	2	01/Aug - 10/Aug
DEF	Texas	10	01/Aug - 10/Aug
GHI	New York	4	01/Aug - 10/Aug
GHI	California	5	01/Aug - 10/Aug
GHI	Texas	7	01/Aug - 10/Aug

Reseller	State	Value System 2	Financial Period
ABC	New York	1	01/Aug - 10/Aug
ABC	California	3	01/Aug - 10/Aug
ABC	Texas	4	01/Aug - 10/Aug
DEF	New York	5	01/Aug - 10/Aug
DEF	California	2	01/Aug - 10/Aug
DEF	Texas	3	01/Aug - 10/Aug
GHI	New York	5	01/Aug - 10/Aug
GHI	California	7	01/Aug - 10/Aug
GHI	Texas	4	01/Aug - 10/Aug

[Greg_Deckler · Accepted solution]

@Anonymous - Can you create a combo key like this? Deja vu?

Key = [Reseller] & "-" & [State]

In both tables. Form your relationship on that?

[Anonymous]

Thanks, @Greg_Deckler!!

I'm gonna try it on my actual data later.