Forum Discussion
columns summary
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, ...
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]) )
Thanks a Lot, it is working! István
