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))
