Count number of rows per field and place in List Box

[jonastemin]

I have a Straight Table chart (named CH244) where one of the fields is Customer.

I've made a simple example table below;

Customer	Qty	Date
Customer #1	1	2018-10-25
Customer #1	4	2018-10-25
Customer #1	10	2018-10-22
Customer #2	6	2018-09-22
Customer #3	9	2018-10-11

I have a List Box with the same field, Customer. I would like to present the number of rows in the straight table in the List Box. Output should look like (where the number of rows is presented in the parentheses;

Customer
Customer #1 (3)
Customer #2 (1)
Customer #3 (1)

Can this be done and how?

Regards,

Jonas

[awhitfield]

HI Jonas,

You could just enable the 'Show Frequency" check box of you list box. You won't get the brackets, but hey!

Andy

[sunny_talwar]

Here are the two options.... one uses the Expression tab to create the count other one uses Aggr() function on the general tab with an expression to do it.