how can we calculate cummulative percentage in MDX

Actually in my application i had a calculated member which calculates the %
of a measure ..and to that calculated member i need to apply cumulative
percentage.
Like if i'm calculating the percentage for the first cell its formulae must
be

cell1/sum(all cells), and if i want it for 2 nd cell its formulae must be
(cell1+cell2)/sum(all cells), and if i want it for 3rd cell its formulae
must be
(cell1+cell2+cell3)/sum(all cells)

is there any possibility to do this in mdx ? if there is any...can any one
please suggest me some links.

Thanks in advance.


--
Sunil

Hi elad,

Thanks for your suggestion. Its working for me ith the time dimension.
But our client wants it to work on the sorting order of a particular
measure.
ie, we can apply the same formulae but we need to sort the output based
on the value of the measure..

This is my formulae

sum(PeriodsToDate([Date].[Fiscal Month SC].[(All)],[Date].[Fiscal Month
SC].currentmember),[Measures].[ss])

I need to modify it to sort the output based on a measure called
weight.. ie, we had to sort it based on the weight either ascending or
descending. Is this possible in MDX ?

Sunil

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

hi elad,

Thanks for your suggestion to use order() function. I tried using that
function to create a calculated member but failed in doing it. can i use
order() function to calculated members?

Actually i created a calculated member for cumulative frequency and
another for the weight factor. This cumulative frequency is showing the
output correctly with the PTD function. But they want this cumulative
frequency to sort by weight factor(calculated member) ..so, i need to
use orders() to sort this cumulative frequency using weight factor..

How to apply orders() function on a calculated member (cumm frequency)
to sort based on another calculated member(weight factor)... if its
impossible we have one more option like we can make weight weightfactor
as dimension measure... if we make weight factor as dimension measure
will it work for us ??

Thanks for your help man...

Sunil.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!