Is there a way to achieve this calculation? pls see the post for details

[ryanzhang487]

Hi community, 

I have two tables, I would want to calculate the sum of pension amount all time (which is 150, in main table) then multiply the corresponding item's percentage (in distribution table) for corresponding months, (for example Apple would be 150 *0.2+150*0.3 = 75),

the third picture in highlight would be the the result I want to simply display in Tableau,

sample excel file attached, I hope that make sense, 

Thank you for your help

main data: 

distribution table:

final desired display highlight in yellow, and the logic: 

   

[Qiu · Accepted solution]

@ryanzhang487 
I was not able to fully understand the logic here. just tried to replicate your output. Hope it works.

[ryanzhang487]

Thanks a lot! that is right

[Qiu]

Glad to be any help

[ryanzhang487]

Thank you Qiu, you are very helpful and I posted another question,

could you please take a look for me? thank you so much

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Is-there-a-way-to-achieve-this-calcula...