Forum Discussion

Michelle Wipfler's avatar
Michelle Wipfler
Copper Contributor
Sep 29, 2017

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 as assignor.
Formulas and Functions

2 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Oct 03, 2017

    And if with PivotTable

    1) Create relationships between table (ribbon Data->Relationships)

    2) Create PivotTable based on Table1, be sure it is added to data model. Right click on table name in the pane and add measure

    3) Edit formula for the measure as below and add it to PivotTable

     

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Oct 03, 2017

    Hi Michelle,

     

    If i understood you correctly you may use SUMIF

    =[@Amount]-SUMIF(Table2[Assignor],[@Assignee],Table2[Amount])

     

     

Resources