Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want a function that shows top values..as in top 5 or 10
plz write the syntax also
thanks
here you have an example
for charts u can use dimension limits , for expressions u can use rank function.
it may be useful.
Use rank function
In the chart properties-> dimension limit-> eable (limit ) and select 3
Hi,
User Rank Function
like this
=aggr(if(rank(sum(Sales))<=3,[Sales Point]),[Sales Point])
Check enclosed file for TOP 5.. Use 3 instead of 5.
In case you using QV 11 use dimension limits.
as said earlier RANK will also solve your query.
Deepak ,
See the attachments.
Thanks,
AS