mdx - Period on Period growth for a dynamic measure -

mdx - Period on Period growth for a dynamic measure -

i wrote mdx script showing period on period growth net sales amount, , works fine. using interface, can place slicer user can take dimension of date.calendar interested in, i.e.whatever dimension of date.calendar user decides take (quarter, month, year) correctly @ previous member. now, im trying obtain same measure - i.e. want flexible dependant on measure user take in slicer ( i.e. net taxation amount).

i cant think of way of creating previous fellow member measure beingness flexible...

with fellow member [measures].[internet sales amount pp] ( [date].[calendar].currentmember.prevmember, [measures].[internet sales amount] ) fellow member [measures].[period on period grwth %] iif ( [measures].[internet sales amount pp] = 0, 'n/a', ([measures].[internet sales amount]-[measures].[internet sales amount pp]) /[measures]. [internet sales amount pp] ) ,format_string = "percent" select [date].[calendar].[month] on rows, {[measures].[internet sales amount], [measures].[internet sales amount pp], [measures].[period on period grwth %]} on columns [adventure works]

if happen utilize ssrs, can add together parameter absorb measure selected in drop downwards front end end. host ssrs in sharepoint environment , how it.

with fellow member [measures].[measure growth pp] ( [date].[calendar].currentmember.prevmember, strtomember('[measures].'+ @measureselected) ) fellow member [measures].[period on period grwth %] iif ( [measures].[measure growth pp] = 0, 'n/a', (strtomember('[measures].'+ @measureselected)-[measures].[measure growth pp]) / [measures].[measure growth pp] ) ,format_string = "percent" select [date].[calendar].[month] on rows, {strtomember('[measures].'+ @measureselected), [measures].[measure growth pp], [measures].[period on period grwth %]} on columns [adventure works]

mdx