aggr set analysis query

[#1]

Hi all,

I have an expression as follows:

count(distinct aggr(if(sum(AnnRevs) > vAnnREVsSlider,[Client]),[Client]))

Basically, if a client has a larger Revenue than the current slider value, count the client.

This is within a text box*

The problem is, I want to not have the number change once a client is selected.

e.g. if 100 clients have AnnRevs > 100, I want the value in the text box to remain at 100 when one client is selected.  I've tried various forms of set analysis with no luck.

Any ideas?

Thanks

[#2 · Accepted solution]

Think I;ve solved it actually!

sum({<[Client] = >}if(aggr({<[Client] = >}sum({<[Client] = >}(AnnRevs) [Client]) > vAnnREVsSlider,1))