Q1 This query returns the running sum value for only one customer – customer number 3,650. With Member Measures.X as 'SUM(Customers.CurrentMember.Level.Members(0):Customers.CurrentMember, Measures.[Store Sales])' SELECT {Measures.[X]} on COLUMNS, {[Customers].[Name].Members.Item(3650)} on ROWS FROM Sales Q2 This second query returns the running sum for 3,650 different customers – from customer 1 to customer 3,650. With Member Measures.X as 'SUM(Customers.CurrentMember.Level.Members(0):Customers.CurrentMember, Measures.[Store Sales])' SELECT {Measures.[X]} on COLUMNS, {[Customers].[Name].Members.Item(0):[Customers].[Name].Members.Item(3650)} on ROWS from Sales Q3 This query returns the running sum value for only one customer – customer number 3,650. With Member Measures.X as '(Customers.PrevMember,Measures.CurrentMember) + (Customers.CurrentMember,Measures.[Store Sales])' SELECT {Measures.[X]} on COLUMNS, {[Customers].[Name].Members.Item(3650)} on ROWS FROM Sales Q4 This second query returns the running sum for 3,650 different customers – from customer 1 to customer 3,650. With Member Measures.X as '(Customers.PrevMember, Measures.CurrentMember) + (Customers.CurrentMember,Measures.[Store Sales])' SELECT {Measures.[X]} on COLUMNS, {[Customers].[Name].Members.Item(0):[Customers].[Name].Members.Item(3650)} on ROWS from Sales With Member Measures.X as 'SUM(NonEmptyCrossJoin(Customers.CurrentMember.Level.MEMBERS(0):Customers.CurrentMember), Measures.[Store Sales])' SELECT {Measures.[X]} on COLUMNS, {[Customers].[Name].Members.Item(0):[Customers].[Name].Members.Item(3650)} on ROWS from Sales With Member Measures.DollarSales as 'SUM(Descendants(Customers,[Name],SELF), [Measures].[Store Sales] * [Measures].[Sales Count])' SELECT {DollarSales} on COLUMNS from Sales With Member Measures.DollarSales as 'SUM(Descendants(Customers,[Name],SELF) * Descendants(Product,[Product Name],SELF), [Measures].[Store Sales] * [Measures].[Sales Count])' SELECT {DollarSales} on COLUMNS from Sales With Member Measures.DollarSales as 'SUM(NonEmptyCrossJoin(Descendants(Customers,[Name],SELF) * Descendants(Product,[Product Name],SELF)), [Measures].[Store Sales] * [Measures].[Sales Count])' SELECT {DollarSales} on COLUMNS from Sales