List Box - Condition

[#1]

Hello Community!

How do you add a list box that shows ONLY the company names that are associated with sales/orders (i.e. %Fact_Key is not null)?

Thank you for any assistance!

[JonnyPoole]

Change the list box 'field' to be an expression and enter something like this:

=if( aggr(sum(Sales)>0,Customer) , Customer)

[maxgro]

maybe with an expression in listbox

=if(aggr(count(%Fact_Key ),company)>0,company)