Hi There

The following is a portion of a cube spec

<Measure name="Gross Profit" column="gross_profit" datatype="Numeric" aggregator="sum" visible="true"></Measure>
<Measure name="Net Sales" column="net_sales" datatype="Numeric" aggregator="sum" visible="true"></Measure>
<CalculatedMember name="Gross Profit % Net Sales" formula="[Measures].[Gross Profit] / [Measures].[Net Sales]" dimension="Measures" visible="true"></CalculatedMember>
<CalculatedMember name="Gross Profit % Net Sales (YTD)" formula="Aggregate(YTD([Date].CurrentMember), [Measures].[Gross Profit % Net Sales])" dimension="Measures" visible="true"></CalculatedMember>


If I now write the following MDX

select [Measures].[Gross Profit % Net Sales (YTD)] on columns
from [cube]
where [Date].[2011].[12]


The YTD calculated measures result is summed instead of first summing gross profit and net sales and then dividing. I have googled this a while and as I understand this is the way Mondrian currently works.

If not please can someone point in the right direction.

Thanks Much
Angus