using aggr inside a set expression

Anonymous — Tue, 02 Aug 2016 16:25:34 GMT

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

Re: using aggr inside a set expression

sunny_talwar — Tue, 02 Aug 2016 16:27:49 GMT

May be this:

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

Anonymous — Tue, 02 Aug 2016 16:38:53 GMT

Thanks!