columns summary

[ihogye]

Hi,

Can You help me define the rith setup of calculation about this sample file:

After multiplication of Cap & Qty the sum of colum not rigth, but I understant why show / calculate this sum, but I need to modify to the multiplication of calculated cells... as the 2nd table showing. Can You help me?

 

Thanks, István

[amitchandak]

@ihogye , Try should try like

Sumx(Values(Norm[Model]), calculate(Sum(Prod[Qty]) *Sum(Norm[CAP1) ) )

You might need common dim table

if the relationship is 1 to Many from Norm to Prod

Sumx(Prod, Prod[Qty]* related(Norm[CAP1]) )

[ihogye]

Thanks a Lot, it is working! István