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.