Thanks for your replies! Actually we might have solved it already, I just forgot to update this post :smileyblush: A colleague of mine had some spare time so he sat down with this problem, and after some trial and error he came up with a working solution. When he specified the measure over all dimensions but the time dimension (if that makes any sense, I don’t know how to express it) as denominator, the result was the total Quantity for any given month regardless of what drilldowns had been made in the other dimensions. So for my example above the MDX for calculating the ratio would look like this (it probably says more than my attempt at an explanation): [MEASURES].[Quantity] / ([MEASURES].[Quantity],[Geography].[All Geography],[Gender].[All Gender]) In short, just line up all dimensions in the cube apart from the time dimension in the denominator: [MEASURES].[measure] / ([MEASURES].[measure],[Dimension-1].[All Dimension-1],[Dimension-2].[All Dimension-2],[Dimension-3].[All Dimension-3], … ,[Dimension-n].[All Dimension-n])
... View more
