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...
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