Set analysis Sum of Averages..

[Aag]

Hello all, I am new to Qlik and need help 

I need to do a calculation sum(Sales)/sum(Profit). 

I am calculating Num and denominator separately, and I have to calculate ony for certain category types.. 

For Numerator, I created Measure1 :  Sum{<Category= {'ABC','DEF'}>} Sales)

For Denominator, I created Measure2: Need to first calculate the average :  Avg({<Category= {'ABC','DEF'}>} Profit)

How do I calculate sum of Measure2? using set analysis? 

[Taoufiq_Zarra · Accepted solution]

@Aag  If I understood correctly are you looking for measure 2 this ?

sum(aggr(Avg({<Category= {'ABC','DEF'}>} Profit),Dimension(s)))

Dimension(s)-> Dimension1,Dimension2... => dimensions you use in the chart

[Aag]

Awesome! This calculation did the trick!! Thanks a ton @Taoufiq_Zarra