Summarize (Pivot) Table

Hi Anonymous,

Sorry, I haven't described my scenario clearly.

The formula I shared in my second reply should be useful when you created the relationship with Link colunm for the two tables.

If you don't have relationship, you should use this formula below.

Column = CALCULATE (
    SUM ( Table2[FTE Proportion] ),
    FILTER ( 'Table2','Table2'[Link]=EARLIER(Table1[Link] ) )
)

---

 Just wondering if there are values in 'Table1', but no matching value in 'Table2' if it will return a value of zero, or if it will cause a problem? 

 

---

For your question, I think this expample should explain this scenario. In Table 1, we have different links but in Table 2 we only have one matched link. For the result column, we could see if there is no matched values in table 2, it will show blank in Table1.

I also made a simple example which should make you clear.

Best  Regards,

Cherry