Applying MDX formula on more than one measure, How? -
02-21-2006
, 07:02 AM
How can i apply a certain formula to evaluate a year-to-year growth
rate like the following one on more than one measure, "i know to apply
it in only one measure, follow this link to know "
http://groups.google.com/group/micro...9dcb2c157b2a26
the formula is :
[(X2/X1) - 1] * 100
X2 is the value of year (assume YEAR dimension in the vertical axis
with no change) that i want to calculate its growth rate,
X1 is the vale of the previous year.
Any suggesions will be appreciated,
Thanx in advance.
Abobakr Nasr
Database Designer
Cairo, Egypt. |