Get partial sum through mapping table

[imhappiee]

Hi

find the sample attached to find the source data ,mapping data and output needed n QlikView

To detail

I have actors who had different types of Hits and the budgets associated with it as shown in the img below

I have created a mapping file to create a convenience to modify my selection based on the requirement using flags

So i want the source to be bridged and calculated by using that mapping file

the calculation is as per the following

kindly come up with possible solutions and help me out ...

Note:

attach the file along with your post if experimented with this data

Thanks

Happiee.

[imhappiee]

Any help?