Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Rank function is not working properly can you please suggest on this.
=IF(Aggr(Rank(SUM(CollectionAmount)),CustNo1)<=$(vTopcustomer),CustNo1)
Thanks
What exact issue you are running into?
Maybe this:
=IF(Aggr(Rank(SUM(CollectionAmount))<=$(vTopcustomer),CustNo1),CustNo1)
- Marcus
Or
=Aggr(If( Rank(SUM(CollectionAmount))<=$(vTopcustomer),CustNo1),CustNo1)
This could be used as a calculated dimension, for example.
If you want to use it as expression, you should chose and use an appropriate outer aggregation function.
hi ,
after using this expression still i am getting same problem
Example : multi line box selcting 10 displaying customer values
20 not displaying customer values
30 not displaying customer values
50 not displaying customer values
thanks ,
Sorry, I don't understand this scenario you are describing.
Could you post some more details, e.g. screenshots, or better a small sample QVW?