Frequency total in list box

[#1]

Hi i wnat my list box to contain in brackets the frequency it occurs. So far i have only managed to contain in brackets the total count of all rather then the specified field count [PROJECT]. Hopefully the images below can illustrate.

Current List box and expression

1st attempt of list box and expression

Example of how i want it to look

Any ideas?

[#2]

Hi

You can mark

Show Frequency in General tab.

Regards

Anders

[#3 · Accepted solution]

Hi

You can also try

=PROJECT & '- (' & aggr(count(PROJECT),PROJECT) & ')'

Regards

Anders