Hi!

I have a measure Quantity.

I want to show the percentages when drill down according to year..

ALL YEAR 2000
+2004 500
+2005 1500

How can I do this?

I need the result as

ALL YEAR
+2004 500 %25
+2005 1500 %75

Hi, Zitus.

Would you like a expression for the cube scope calculated member or just for
the query scope calculated member? On what dimension should this member?

I can give you one example, but it is not universal, because it goes on the
explicit given Dimension. Here is the Time Dimension.

([Measures].[Sales Amount], [Time].currentmember)*100/([Measures].[Sales
Amount], [Time].[All Time])

Thanks,

Vladimir Chtepa




"zitus" <zitus (AT) community (DOT) nospam> schrieb im Newsbeitrag
news:e5pnXTNGFHA.1740 (AT) TK2MSFTNGP09 (DOT) phx.gbl...