How to restrict prompt values in Dashboard Prompt

Question

Hi Experts,

Could you help me restrict the prompt values in the dashboard prompt?

I'm using this dashboard & column, "Recruiting - Recruiting Real Time"."Job Requisition - Progression"."Current Phase"  and wants to show only five values in the dropdown list, like,

Thanks

gclampitt · Accepted Answer

Just click on options and choose whats appropriate for the LOV.

eg can select "specific column values" and just enter the values you want

or "SQL results" to include some logic to what you want returning etc