running total after sorting

[anuragvijay]

is it possible to write a MDX expression to create a calculated member to calculate a running total on a measure but after sorting it in ascending order?

 

[pabloj]

Do you want the calculated member to be something like a sum of the top x customers?

Stick to your guns

 

[anuragvijay]

Hi pabloj,

This is what i want:

if column A has 3 values: 1,2,3 then the calculated member column (the one having the running sum) should have the following values: 1, 3, 6

that is: 1, 1+2=3, 3+3=6

thanks

 

[MDXer]

try something like

([Dimension].CurrentMember, [Measures].[Your Measure]) + ([Dimension].PrevMember, [Measures].[This Calc Measure])

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck