Total<> unexpected behavior

[romansysyuk]

There is a Table with 3 dimensions and one measure Measure1 = Sum(X).

Dimension1 Dimension2 Dimension3 Measure1 Measure2

Dimension1	Dimension2	Dimension3	Measure1	Measure2
1	A	i	10	100
2	A	i	100	100
3	A	q	30	30
4	B	q	40	40
5	B	d	30	30
6	B	d	30	30

I need to create second measure with Max Measure1 result aggregated by Dimension2&Dimension3 (ignoring Dimension1).

Theoretically formula bellow should work

Max(
    TOTAL <Dimension2,Dimension3>
    Aggr(
        Sum(X)
        ,Dimension1,Dimension2,Dimension3))

But it shows 

Dimension1 Dimension2 Dimension3 Measure1 Measure2

Dimension1	Dimension2	Dimension3	Measure1	Measure2
1	A	i	10	100
2	A	i	100	100
3	A	q	30	100
4	B	q	40	40
5	B	d	30	40
6	B	d	30	40

I could expect such a result with the formula

Max(
    TOTAL <Dimension2>
    Aggr(
        Sum(X)
        ,Dimension1,Dimension2,Dimension3))

So the formula part "TOTAL <Dimension2,Dimension3> " doesn't work as I expect.

A workaround works for me - to add next formula as a dimension

Aggr(
    Max(
        Aggr(
            Sum(X)
            ,Dimension1,Dimension2,Dimension3))
    ,Dimension2,Dimension3)

But the question is still actual:

why the Total part of the formula doesn't make aggregation grouping it with all needed dimensions?

Max(
    TOTAL <Dimension2,Dimension3>
    Aggr(
        Sum(X)
        ,Dimension1,Dimension2,Dimension3))

[Ksrinivasan]

hi,

can you share real result table. what you have expected,

ksrinivasan