Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had the following calculated dimension in my QV application:
Now i want to replace with something like the following:
Is the above workable?
Regards
Yes, an expression like this should work:
=If(aggr(Rank(Sum(Amount)),$(=GetCurrentField("LeadingACT3")) )<=20,$(=GetCurrentField("LeadingACT3")))
But in most charts you can use dimension limits instead which are a lot easier and will probably perform better.
Yes, an expression like this should work:
=If(aggr(Rank(Sum(Amount)),$(=GetCurrentField("LeadingACT3")) )<=20,$(=GetCurrentField("LeadingACT3")))
But in most charts you can use dimension limits instead which are a lot easier and will probably perform better.
Thanks Gysbert
If the issue has been resolved, would you be able to close this thread? If it hasn't been resolved, would you be able to point out what isn't still working?