Aggregation of Set Analysis

[Anonymous]

Dear Community,

i want to aggregate a set analyis like following:

Get SUM of COUNTED VALUES that are GREATER THAN a VALUE_LIMIT AGGREGATED OVER VALUE_GROUP

I tried follwoing without luck :

SUM(AGGR(COUNT({<VALUE= {">$(= [VALUE_LIMIT])"}>} VALUE),VALUE_GROUP))

I read a lot of topics about smiliar problems, but nothing helped me.

Maybe the aggreagation should happen at a deeper level, inside the Set Analysis.

Any idea how to solve this?

[Anonymous]

Hi!

we are useing Option1

and with this its finally working!

     SUM(AGGR(Sum(If(Value >= [Value Limit], 1, 0)),[Value Group]))

Thanks to all for your support!