Hi all, I’ve been trying to create a calculated measure in Cube Studio for calculating a ratio, but I’m stuck and could use some assistance. My problem is the following: As an example let’s say we have a cube with three dimensions, Time, Geography and Gender, and one measure, Quantity. The Time dimension only has one level, month, in the format YYYY-MM. What I would like to have is a new measure that calculates the ratio per month. If I create a report in WRS based on the cube and set a group break on the Time dimension, it would look something like this if I for instance select month 2011-09 (where the total for Quantity is 12): Geography Gender Quantity Ratio Africa Female 2 16,7% Africa Male 2 16,7% Asia Female 2 16,7% Asia Male 1 8,2% Europe Female 2 16,7% Europe Male 3 25% Somehow I want to use the grand total of Qantity for whatever month I’m currently looking at as denominator in the calculation so that the formula will be 'Value in current cell' / 'Grand total for current month', but I can’t figure out how to accomplish that. Any help is appreciated! Thanks in advance, Ulf
... View more