Aggr of a Pivot's Expression

[Anonymous]

Dear All,

I'm wondering if is possible use as expression in function Aggr a "precalculated expression" used in the same Pivot Table.

See below the example:

I hope it's clear

Thanks

[swuehl]

No, you can't reference expression using the expression label in the aggr().

You can duplicate the expression(s) content within the aggr() as a workaround.

[Anonymous]

Thanks Stefan for the quick reply.

As I have long and repetitive expressions I will try to use $(variables) to avoid writing the same expressions many times.