Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
You can also try
=PROJECT & '- (' & aggr(count(PROJECT),PROJECT) & ')'
Regards
Anders
Hi
You can mark
Show Frequency in General tab.
Regards
Anders
Hi
You can also try
=PROJECT & '- (' & aggr(count(PROJECT),PROJECT) & ')'
Regards
Anders