List Box

[upaliwije]

Hi Friend

I want to create a list box from the follwing data

type  amount

A   353,161,194

C   331,580,299

D   103,830,798

E   80,021,097

F   71,169,157

G   55,730,523

H   46,427,949

I    42,685,470

J   40,854,726

K   40,133,870

L   34,124,681

M   30,639,061

N   30,505,397

O   29,234,780

In this list box I want to show only  top  10 types  (A-J) based on  higest amount. Pls help me

[kaushiknsolanki · Accepted solution]

Try this.

Right click on Sheet and click on Create new sheet object and select List box.

Now scroll down to the last record in Field Section and Select "Expression" And type below expression

=aggr(If(Rank(Sum(Amount))<=10,Type),Type)

Regards,

Kaushik Solanki