Nested aggregation of variables

[#1]

Hi,

I have a variable that is created in an excel and imported and has a sum function applied to it. Further within the design, I need to set analysis again on this variable to apply few more filters, but I am unable to use set analysis either a sum or count functions as it already has a sum function. Summing the variable again is not a concern, but I need to apply further filters on this using set analysis, how do I achieve this. Any suggestions are appreciated.

[petter]

The Aggr() - function is exactly created to allow for nested aggregations which also allows you to use additional set analysis. If you don't need the nested aggregations then you should be able to put all your set expressions into one.

[#3]

Hi Peter,

So I have a variable vVariable1 which is

vVariable1 = Sum(Field1)-Sum(Field2)

Now I am using this variable in a chart, to get MTD values

what I want is to further apply set analysis on this variable to get MTD, can you please provide with an example how to achieve that

I have the set analysis formula for the MTD I just need to know how to put that together with this variable something similar to the below,

Sum({<MTD Set Analysis}>} $(vVariable1))

[petter]

I think you can add the MTD Set Expression into each of the sums.