Skip to Content
author's profile photo Former Member
Former Member

List Box behave like Filter

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 01, 2012 at 04:58 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.