Grand Total of different group totals in crosstab, DMR.

[Kyne]

Hi,

I'm having difficulty of calculating grand total of separated totals in crosstab based on DMR.

in the crosstab,
there are 3 groups in a hierarchy of [All-Region-Warehouse].
I've already created regional totals by using just dimensional edge summary for each region, children(A), children(B), and children(C).
but what i cannot go further is getting the grand total of children(A)+(B)+(C).

each total is dimensional edge summary and the dataitem is Total(children(A)) and etc.
i've tried the query calculation of Total(children(A)) + Total(children(B))+ Total(children(C)).
but, it failed with the error of "The dimensions on the edge are inconsistent. A dimension of valueSet="37" is not the leaf on the first path.".

Is there anyone who had faced the same issue and sorted out?
Please help me out of this problem.

Thanks in advance.

[MFGF]

Hi,

Isn't it simply a matter of summing the A, B and C member measures? Or am I missing something?

You could try

A + B + C

Or alternatively

Aggregate(currentMeasure within set set(A,B,C))

MF