Forum Discussion

baronraghu's avatar
baronraghu
Icon for Helper III rankHelper III
7 years ago
Solved

Multiply two tables

Hi All,

 

I am trying to determine work allocation based on the information given in the below tables.

 

Table 1 has three columns 

Table 2

 

What I want to achieve is when I select like "GA 10.1" on the slicer  then a table must be created which gives how much portion of work will be completed end of each calender Year

 

like

2018      0

2019      0

2020     1001011*10%*(9/12)= 75076

2021     (1001011*10%*(3/12))+(1001011*20%*(9/12))

and so on

 

 

 

 

5 Replies