Expression issue in aggregation

[ravindraa]

Hi Exports,

  I have small issue on Multiplication .i have two tables like sales_file and price_file like below.

Country      SAPcode     year      Month       sales                       Country      SAPcode     year      Month       Price

AE                 12345           2019     1                 10                              AE                  12345           2019      1                2

AE                  23456          2019     2                 20                             AE                   23456            2019      2                3

Normal Process:-Normally if we load the data and create the expression like sum(sales)* sum(price) result is = 30*5  =150

Required Process:-but my requirement is in 2019 Jan month sales is 10 and same year same month price is 2 then multiply like 10*2 =20

same way second month also in 2019 Feb month sales is 20 and same year same month price is 3 then multiply like 20*3=60.

Normal expression is giving like below result

Country    Value(sum(sales) * Sum(Price))                                        Country        Value

AE                150                                                                                                 AE                   80  (Expected Result)

kindly give me any suggestion how to achieve .

I have attached sample application please find the same.

Thank you very much in advance........

[ravindraa]

Hi Experts,

   kindly give any one of  the suggestion last one month on wards i am struggling the same issue .

Please help me .

Thanks in advance......

[ravindraa]

Hi Experts,

   kindly give any one of  the suggestion last one month on wards i am struggling the same issue .

Please help me .

Thanks in advance......

[patilamay]

Hi 

I think you need to do this 

Sum( sales * price)

HTH

Thanks,

[qliksus]

Since you are just taking the country as a dimension you doing

sum(amount)* sum( price) will be   30*5 = 150 

sum(amount * price) will be  ( 10*2 + 20*3) =  80 

hence try sum(amount * price)  if you are taking just one dimension which is not giving the granular details of each row 

[Brett_Bleess]

Did either of the posts help you resolve your question?  If so, be sure to return to the thread and use the Accept as Solution button on the post(s) that helped.  This will give credit to the poster and let other Community Members know what worked.  If you still require further assistance, leave an update.

Regards,
Brett