Calculated field between 2 tables

[Kynesl]

Hi All,

I am looking to creating the total sales amount from two separate tables, each with information required.

table 1

table 2

I need to multiply the 2016 SP by the Sales Qty, but having a struggle calculating these.

All suggestions would be greatly appreciated.

Regards,

Kyne

[marksouzacosta]

Hi Kyne,

Can you share a picture of your Data Model and your Load Script?

Regards,

Mark Costa