calculation of a tuple based on a member in a hierarchy

[anuhya201]

HI everyone,

I am working on DMR on a crosstab reprot.I need to calculate a tuple based on the total of one of the rows and variance%(a column). All my rows are in a hierarchy.

Division Region SalesOffice SalesREp

This is how my rows are. I have a aggregate for the rows. There are four divisions and I need to calculate the tuple for the Total of each division(when you total up the regions u will be able to see the total at the end of each divsion) and the variance% which is a column.

I tried
tuple( parent (currentMember ([SalesMeasurement].[Combined Region].[Combined Region])),[Variance %] )
But it is giving me the total of the sales office.
I tried the "rootmember" tooo. But Its giving me the tuple for total of 4 divisions and the variance.

Please help me out.

Thanks.