Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Think I;ve solved it actually!
sum({<[Client] = >}if(aggr({<[Client] = >}sum({<[Client] = >}(AnnRevs) [Client]) > vAnnREVsSlider,1))
Think I;ve solved it actually!
sum({<[Client] = >}if(aggr({<[Client] = >}sum({<[Client] = >}(AnnRevs) [Client]) > vAnnREVsSlider,1))