Forum Discussion
Pivot Table Help
Hi, I need help linking the attached 2 tables .. ultimately I want to show assignee totals. I'd need to take the items from the first table and subtract out any amounts where the same entity is listed...
Hi Michelle,
If i understood you correctly you may use SUMIF
=[@Amount]-SUMIF(Table2[Assignor],[@Assignee],Table2[Amount])