expression sum over one dimension only

[giakoum]

Good morning

I have a pivot (or straight table) table with 2 dimensions, and 1 expression as in the attached example (Count(MVCDE)*MZPRT). I need to compare the expression total over dimension DESTINAZIONE to the original expression.

This should be somehow straight forward, but I am unable to get it right. So I need a new column in QV as column F in the attached excel.

Any ideas?

Thank you

[whiteline · Accepted solution]

This gives what you want:

=Sum(total<DESTINAZIONE> aggr(distinct Count(MVCDE)*MZPRT, DESTINAZIONE, MEZZO))

[giakoum]

thank you!