Total<> unexpected behavior

romansysyuk — Sat, 16 Nov 2024 00:47:38 GMT

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

Dimension1 Dimension2 Dimension3 Measure1 Measure2

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

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

Re: Total<> unexpected behavior

Ksrinivasan — Tue, 19 Jan 2021 16:47:16 GMT

hi,

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

ksrinivasan