Power Pivot Question

arob92

New Member
Joined
Apr 16, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,114,255
Messages
5,546,801
Members
410,759
Latest member
Bufnercash
Top