"ALL" option in prompt

[new_user01]

Do we have or can show by any means "All" option in prompts in our dashboards.    Ex-- we are having 2 prompts in our dashboard 1.Region prompt and 2. District prompt.
Suppose there are two regions East and West. In east region we are having 4 districts  and in west we are having 5 district.
So,if we are selecting east region then corresponding district which are present in east region will be displayed in district prompt.

The requirement is that we want the "All"  option(functionality) in district prompt,so that we can see the aggregated values for all the districts in our dashboard by selecting "All"  when east or west region is selected.

Thanks

[TruthSeeker]

Make the prompt optional and in the text description indicate that leaving it blank will get everything.

[ncrowsey]

Type this prompt macro in your SQL. 
AND  (#Prompt('pDistrict')# = 'ALL' OR TABLE.DISTRICT  LIKE  #Prompt('pDistrict')#||'%')

This will show all in your value prompt. 

[Satheesh]

Hi,




Select the district Value Prompt go to properties, Find and click on Static Choices, Click on Add button make Use and Displays names as 'All' Click Ok.


And Apply the Filter for the corresponding Query.


You should get.




Sateesh