Percentage measure question?

[RoelantOLAP]

Dear all,

Im having problems calculating % in Analysis Server. I use the following to calculate % across all dimensions:

([Measure]/([Measure], [Dim1].[All Dim1],[Dim2].[All Dim2],[Dim3].[All Dim3))

The problem is, these percentages only correspond to the top level amount. Im looking for an way to drill down and get the right % for the totals of the sub-levels. I have the following for a single dimension:

[Measure]/([Measure], Ancestor([Dim].CurrentMember,1))

But this only works for the specified dimension. Im looking for a way to make this work for all dimensions.

For instance: if you have stores against time in % you get like

all stores 100%
canada 75%
usa 25%

if you drill down (USA) you get

all stores 100%
canada 75%
usa 25
washington 10
seattle 15

and i want the city's to total 100% per country!

Can anyone help me out?