Grading out selections in multi box(dropdown)

[#1]

Hi,

I nedd to keep the selections in multibox(dropdown).

I am keeping location and product as the slicers.

when i select a lcation only the related products shold be shown in the other multibox.

other products should not even be displayed as unselected or we should not even get the empty space if we enable hide excluded.

How do i acheive this?

Please help.

its urgent.

Thanks in advance.

[prieper]

Think you cannot achieve this with a listbox. But you may create a chart or table containing only this one field and play around with the formatting that it will look like a listbox.

HTH
Peter