how to calculate original retail

[ali_hijazi]

Hello

I got two tables in a qvw document (Inventory Transactions and another for Retail)

the original retail means

getting the for each item the first Retail Date and multiplying it by the sum of quantities in Inventory (of type in ) up to a specific date

the chart will have several dimension:

Country, Business Unit and Season

Please advise