How to create drop downs

[BETO]

hi I have a request that will allow the users to do drop downs

here is the raw data

REGION   SITE.     STATE.  DISTRICT. MON TUE WED THURSDAY FRI.  test

1.                A1.         tx.             W.texas.  10.     0.    15.       24.            45.     yes

what I need is to look like this I need to look at raw data a if day of week is greater than 12 it counts as one in this case 2 days ....what I need is for the person to select region 1 and the raw data will appear an once open. They can select district an it keeps going down in a hierachy to site Id ....I hope in make sense thanks for all the help

Region          1 times 2 times 3 times 4 times 5 times

1.                                   One

2

3

4

5

[Cynthia_sas]

Hi:

  This sounds like the type of cascading prompt that you would build for a stored process. For example, here's a screen shot of the prompting interface that shows a different list of countries depending on the first prompt the users selected. Do you have the BI Platform and have you used the prompting interface?

cynthia

(Sorry, I can't seem to post an image right now. I will try to post the image in a bit.)

[Cynthia_sas]

posting picture of cascading prompt example: