Calculated measures - Proportion on total/subtotal

Hello.

Having a cube with a Quarter dimension and a Net price measure, I would like to add a calculated measure that calculates the portion of a dimension versus the same dimension subtotal:


It is possible?

It is possible to do the same on totals and grand totals too?

And, if it is, how?

Thanks in advance.

Lorenzo Radice

Leave a Comment