Bast way to apply case satement for prompt

user12863665

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

You want to display the month selected in a column or in narrative view? Do you want to show all the results from month 1 to month 5?

user12863665

My requirement is very simple.

I Have one column - month number(it Has 1,2,3,....12)

my prompt has only one column - month number

my report also has same column in table or pivot view - month number

MY requirement is if I select Month Number - 3 in the prompt I want to display Month Number -1,2,3 rows should be displayed.

if I select  Month Number - 5 in the prompt report should display Month Number -1,2,3,4,5 rows.

just for the sake of example I used month numbers 3 and 5.basically it should work for all months.

Anyone suggest me how can I do this?

green4x

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

DanPryke

Hi,

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

Shams Abbasi

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