Creating a custom list box

[rido1421]

Hi There

I have a list box that I need to limit what selections are available.

I need to force the listbox to look at a one of the Descriptions= "Expenses"

I cant use an if statement in this case , if there is no selection then the listbox will display everything

Im assuming I should use the getselections function in some way...

Basically what I am trying to do is if(Description='Expenses',Cost_Centre) - this would only work if Expenses is selected.

How do I force it to look at Expenses and Display the Cost Centre?

Thank you

[rwunderlich]

How about:

=aggr(Only({<Description={Expenses}>}Cost_Centre),Cost_Centre)