Regarding exclude value selections

[d_koti24]

Hi All,

Hi I have one requirement,I have one table that table contains sales data country and cities wise like this

If i select one city in filters automatically filter the data based on the filter.suppose if i select city Canberra i am getting data like this.

No issues on that,if select any excluded city ,automatically clear the data,and filter based on selection. lie this

if i select Washington,D.C. filter the data based on city like this

But My requirement is if i select any excluded value in multibox ,i want to add that selected data to the existing data in straight table,  like this:

How to achive this?

how to select the excluded value in multibox?with out clearing old data?

Help me on this..

Regards,

kd

[#2]

You can try different drop down style.

[Anonymous]

How about holding down the <Ctrl> button and then clicking the excluded value you wish to add ?

[PabloOrtiz]

Hello, use this option