List Box

upaliwije — Tue, 13 Mar 2018 07:04:15 GMT

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

Re: List Box

kaushiknsolanki — Tue, 13 Mar 2018 07:11:31 GMT

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