Shrinking list boxes to only associated data

[#1]

Hi All

Please can somebody advise what settings are required to shrink a list box to contain only those records relevent to the data displayed on a graph? The list displayed needs to be dynamic based on the selection (e.g. list only those projects associated with a particular Business Unit).

Thanks

[Gysbert_Wassenaar]

Not sure what you want. You can try using expressions instead of fields in the listboxes, i.e. aggr(MyField,MyField) instead of the field MyField.