Bast way to apply case satement for prompt

Question

my requirement is, if i select values 1 - 12 in prompt , below that number should be displayed.

ex: i have month column which has month numbers 1 - 12.

i have same month column in both dashboard prompt and repot.

requirement is, ex:if i select month 5 in the prompt, in report i want to display month numbers 1 - 5.

can anyone suggest me how can this be done in best way.

Shams Abbasi · Answer

As you are using Dashboard, suggestion by green4x will work exactly how you wanted it.

DanPryke · Answer

Hi,

In your report, set a filter on the Month column of 'less than or equal to' the presentation variable you're passing

green4x · Answer

Try to set Operator as "less or equal" in the settings of your promt (for column that you're filterring)