Hi,
I have imported the 3 tables from each of the tabs (medtable, drugtable, ee lookup table) in the attached workbook into the Data Model. Next I built a relationship between the 3 tables based off of the column "Employee Number". I then created the Pivot Table that is on the "pivot" tab.
On the "pivot" tab I have each employee from the "medical" and "drug" tab listen out, and their paid drug claims in column C and paid medical claims in column D. I would like to be able to see their Total Claims in column E. Is there a formula that I could write within the Data Model to have their Total Claims be added as part of the Pivot Table?
Thanks in advanced for the help.
Power Pivot Example - Medical and Drug Claims.xlsx
I have imported the 3 tables from each of the tabs (medtable, drugtable, ee lookup table) in the attached workbook into the Data Model. Next I built a relationship between the 3 tables based off of the column "Employee Number". I then created the Pivot Table that is on the "pivot" tab.
On the "pivot" tab I have each employee from the "medical" and "drug" tab listen out, and their paid drug claims in column C and paid medical claims in column D. I would like to be able to see their Total Claims in column E. Is there a formula that I could write within the Data Model to have their Total Claims be added as part of the Pivot Table?
Thanks in advanced for the help.
Power Pivot Example - Medical and Drug Claims.xlsx
