Nested Aggr()

[rutger_jansen]

Hi,

I'm trying to get the sum of weighted scores within a dimension's class using nested Aggr(). The attached example should clarify what I'm trying to achieve and what I've tried. The real version has some set analysis as well but I don't expect that will make a difference.  

Thanks,

Rutger

[sunny_talwar · Accepted solution]

Try this

Aggr(NODISTINCT 
  Sum(Aggr(
    Sum(sales)/Sum(TOTAL <vehicle> sales) * score
  , vehicle, engine))
, vehicle)

[rutger_jansen]

Thanks very much Sunny.