Set Analysis aggregate with date range

[pirtekmismanage]

Hi community,

I have a set analysis which works fine until I have got one company group selected. If I select more company groups or clear the filter it doesn't show any figures. Just a bit explanation for the data set. Every group has got different start and end date it is like a membership expiration date. I would like to get the sales within their time of membership status. When selecting a month it nicely accumulate month by month and when it reaches the end date it will not show accumulation further only the sales up to the end date. As I said it works perfectly until I have got one company group selected. Any idea what is missing?

SUM(AGGR(SUM({<Event = {'Sales'}, GroupAccountType = {'National'}, New_Renewal={'Re-opened','New'}, DateKeyNum = {">=$(=StartDateNum)<=$(=EndDateNum)"}>} TotalExcVAT),Zone,GroupName,MonthYear))

Thanks in advance for the help.

[sunny_talwar]

Can you let me know what was the exact expression you used?

Is it basically part of the set analysis in this case or still not?

Nope, this is not set analysis... this is an if statement now.