Referring from aggr() to ValueList() value

[Anonymous]

Hello community,

I tried to mix synthetic dimensions (Valuelist()) with calculated dimensions within a pivot,

but it doesn't work as I supposed.

LOAD * INLINE [
F1, F2
A, 1
A, 2
A, 3
B, 10
B, 20
B, 30
];

result:

expected result:

I think with the help of this construct, outstanding pivot solutions would be possible.

Regards

Robin

[sunny_talwar · Accepted solution]

ValueList() cannot be used as an aggr() function's dimension.... try may be with an island table

LOAD * INLINE [

    F1, F2

    A, 1

    A, 2

    A, 3

    B, 10

    B, 20

    B, 30

];

Dim:

LOAD * Inline [

Dim

D1

D2

];

and then your 2nd and 3rd dimensions will be:

Dim

=if(Dim = 'D1', 'X','Y')

Expression

If(Dim='D1', Sum(F2), RangeSum(Sum(F2),1))

[swuehl]

I think calculated dimensions are not possible with aggr() function.

Maybe you can use a data island field instead.

[Anonymous]

Thank you for your answers, that's really a pity.