Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
hi,
can you share real result table. what you have expected,
ksrinivasan