using aggr inside a set expression

[Anonymous]

Hi,

I need to create a complex set expression for a chart, and I'm trying to use an aggr function inside the set expression:

Sum({<Wave=, Edition={"=aggr(only({<Edition=, Wave={11}>} Edition), Edition)"}>}Value)

The target is to collect all waves and all the editions which belong to Wave=11.

But the chart fails to calculate.

Could you make a suggestion what is wrong with this set expression?

Thank you in advance,

Larisa

[sunny_talwar · Accepted solution]

May be this:

Sum({<Wave=, Edition = p({<Wave = {11}>})>}Value)

[Anonymous]

Thanks!