List Box behave like Filter

[Former Member]

Hi excelsius gurus

I have a assignment to complete. I have to use list box who behave like filter box. Let me explain

I have 4 option    1-region      2-country      3-state      4-city

I have to use list box and user want if he select region only that specific region country show up and when he chose that country only that country related state show up and same way the city.

Can some one tell me how we can do that.

Regards

[former_member184839 · Accepted solution]

Hi Sameer,

Here is the filtering of data using List box.

Take 3 list boxes.

Let this be my data.

follow the steps below.

	A	B	C	D	E	F	G	H
1	asia	india	tamilnadu	chennai
2	asia	india	tamilnadu	trishy
3	asia	india	MH	mumbai
4	asia	india	MH	nasik
5	asia	india	K'taka	banglore
6	asia	china	beijing	rgaaa
7	asia	china	beijing	shaanxi
8	asia	china	shanghai	guangdong
9	asia	china	guangdong	dsad
10	america	bahama	Acklins	Berry Islands
11	america	bahama	Acklins	Bimini
12	america	bahama	Acklins	thasj
13	america	USA	Delaware	District of Columbia
14	america	USA	Delaware	yathi
15	america	USA	New York	Maryland
16	america	USA	New Jersey	fthik
17	america	USA	New Jersey	Pennsylvania
18	america	USA	New Jersey	thyik
19	europe	russia	moscow	Estonia
20	europe	russia	moscow	Latvia
21	europe	Latvia	Riga	Vilnius
22	europe	Latvia	Riga	pook

List Box1 :

Labels: A1:A22

Insertion Type : Filtered Rows

Source: A1:D22

Destination: E1:H22

Behavior Tab-

Selected Item :

Type: label

Item: label1

List Box 2 :

Labels: F1:F22

Insertion Type : Filtered Rows

Source: F1:H22 

Destination: I1:K22

Behavior Tab-

Selected Item -

Type: Position

Item: 1

List Box 3 :

Labels: J1:J22

Insertion Type : Filtered Rows

Source: J1:K22  

Destination: L1:M22

Behavior Tab-

Selected Item -

Type: Position

Item: Position 1

This would work. Please get back if you have doubts.

Thanks ,

Sara

[Former Member · Accepted solution]

Hi Sameer,

If your final result is multiple rows ,then you can follow as Sara suggested.

1)If your final final result is only one row ,the you can take filter component .Here take number of rows as 4.So finally you ll ll get only one row.

So with only one component you can achieve.

                          APR  MAY JUN JUL AUG ----

R1 Ctry1 S1 C1

2)  Take a CrossTab Report,In Rows Take Region,Ctry,State,City and columns Month with key Figures.

3)If your final values are more than one row ,then you can go for ListBox or Combo Box as suggested above.

let me know ,if you need anything more.

Regards,

Pappu