Set analysis for variable

Anonymous — Tue, 03 Apr 2018 15:08:46 GMT

So in script editor I define my variables as

set QuantitySold = Sum({<product={'shirts','pants'}, [SERIE]={'Actuals}>} QTY);

and after reload I want to apply set analysis for years like Sum({<Year={'2016'}>} $(QuantitySold) )

Can I do this?

Re: Set analysis for variable

marcus_sommer — Tue, 03 Apr 2018 15:19:31 GMT

In this case you would nest aggregations without to implement an aggr-function and this is not a valid syntax. Maybe you changed it to:

set QuantitySold = Sum({<product={'shirts','pants'}, [SERIE]={'Actuals}, Year ={$1}>} QTY);

and then you call your expression with:

$(QuantitySold(2016))

- Marcus