Forum Discussion
Linking multiple tables using multiple criteria
Hello,
Please see the image below.
I have 3 tables. I'd like to summarize the results data from tables 2 and 3 into a matrix at the bottom.
Table1 contains identifying info with the ID, Name, and Manager being replicated each month. Manager changes are reflected in each new month. I'd like to sum the results from tables 2 and 3 into a column in this table.
Tables 2 and 3 contain results which I'd like to sum using the ID field.
I tried the lookupvalue function but ebneed us seeing the totals replicated in each row in the matrix.
I've spent 2 days on this. Please help!
1 Reply
- amitchandak
Super User
Anonymous , You have column in table 1 like
result 2=
sumx(Filter(Table2, Table2[ID] = Table1[ID] && Table2[month] = Table1[month]), Table2[Result])
result 3=
sumx(Filter(Table3, Table3[ID] = Table1[ID] && Table3[month] = Table1[month]), Table2[Result])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
