Aggregation in qlik sense

[RimDataAnalyst]

Hello ,

I am struggling to insert this formula into Qlik sense , i can't  find the right syntax :

this is the formula :           sum (%spread × fleet volume by Manufacturer) by Product)

i tried this :

sum(Aggr(((aggr(distinct([Product Fleet volume.Fleet Volume] ),[Manufacturer - Name]))*
[Growth axis topic % spread Product.% spread by value axis]),[Product - Name]))

but it doesn't work , i don't know if it is correct or not

thank you

[vinieme12]

the sytanx is as below, but not sure what you are trying to achieve,

Can you some sample data that best represents your actual data 

sum (total < Product> %spread × fleet volume) 

[RimDataAnalyst]

thank you for your answer but unfortunately this doesn't give the right results 

[Angela_Zhou]

I am assume your formula is:

1. sum (%spread × fleet volume  by Manufacturer)
2. sum (<result of above > by Product)

Then, you can try

Sum(Aggr(

sum(Aggr(
   [Growth axis topic % spread Product.% spread by value axis]
   *
   [Product Fleet volume.Fleet Volume]
,[Manufacturer - Name]))

,[Product - Name]))