Search code examples
ssasmdxmeasurecumulative-summsbi

Running Total in MDX


Hi guys I need help I want this result i have trying different queries with MDX in SSAS but doesn't work.

Thank you !

enter image description here


Solution

  • Thank you MoazRub for your answer I used this query and it's work :

    enter link description here

    WITH MEMBER [Measures].[Running Total] AS
      Aggregate (
        { [Date].[Calendar].CurrentMember.Parent.FirstChild : [Date].[Calendar].CurrentMember },
        [Measures].[Internet Sales Amount]
      )
    SELECT
    { [Measures].[Internet Sales Amount], [Measures].[Running Total] } ON 0,
    [Date].[Calendar].[Month].&[2011]&[1].Children ON 1
    FROM [Adventure Works]