Need to replace cell value with dynamic value

[Anonymous]

Hi, I need help to create a dynamic table

Lets say I have 2 table as below 

Table1:

Table2:

What I need:

1. Calculate sum of 2017, 2018, 2019 profit and sum of cost in table2 as below

Year	Profit	Cost
2017	36	10
2018	67	10
2019	36	10

2. I need the sum of profit and cost to be dynamic as i filter the product

 example: Top 3 product based on profit

here is the link of the report

https://drive.google.com/file/d/1vLQ-R4iOiYZC8rbGat_kM4zKRhQ68Phi/view?usp=sharing

I'm new to Power BI so any help will be much appreciate.

[lbendlin]

Your first step will be to unpivot table 1. The rest can then be done in the UI.