Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This gives what you want:
=Sum(total<DESTINAZIONE> aggr(distinct Count(MVCDE)*MZPRT, DESTINAZIONE, MEZZO))
This gives what you want:
=Sum(total<DESTINAZIONE> aggr(distinct Count(MVCDE)*MZPRT, DESTINAZIONE, MEZZO))
thank you!