Top 20 Amount

[sat_tok52]

Hi Guru's,

I want to display top 20 amount on text object ,Any help.

-Sateesh

[sunny_talwar]

In one text box or 20 text boxes?

[sat_tok52]

Thanks Sunny.

In a single text object I want to show  top 20 customers amount .

I wrote like this.

=SUM({<City = {"=Rank(SUM(Sales))<=20"}>}Sales)

-Sateesh

[Saravanan_Desingh]

One way to do..

=Concat({<Amount={"=Rank(Amount)<=20"}>}Amount,Chr(10))

[MK_QSL]

Your expression looks ok... What's wrong ?

Just replace City with Customer!

[jyothish8807]

Hi Sateesh,

Try like this:

concat(SUM({<City = {"=Rank(SUM(Sales))<=20"}>}Sales),',')

Regards

KC

[brijesh1991]

Concate will work; Why don't you go with listbox and restrict top 20 by rank function and then remove caption and all... it will also give you a fleixibility to filter something!

[MK_QSL]

Use something like this in text box

=CONCAT(IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Aggr(Customer& ' : ' & CHR(9) & Num(SUM(Sales),'#,##0'),Customer)),CHR(10),-Aggr(SUM(Sales),Customer))

[MK_QSL]

Or

=CONCAT(IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Aggr('Rank : ' & Rank(SUM(Sales),4) & CHR(9) &  Customer& ' : ' & CHR(9) & Num(SUM(Sales),'#,##0'),Customer)),CHR(10),-Aggr(SUM(Sales),Customer))

This will give you top 5. You can change number accordingly to your need.