How to make field Month_n into list box with 4 selection for filter month ?

[paulyeo11]

Hi All

I have a field month_n

if i click 0 , it will select current month.

if i click -1 , it will select Next month.

if i click -2 , it will select Next 2 month.

if i click -9 , it will select Next 9 month.

Now i like to make this become a list box.

which have 4 choice :-

if user select 0 , it will filter current month.

if user select -1 , it will filter current till next month.

if user select -2 , it will filter current till next 2 month.

if user select -9 , it will filter current till next 9 month.

Cacn some one share with me how to do it ?

I assume some thing like below :-

=IF([Month_n]<='0','0',

IF([Month_n]<='-1','-1',

IF([Month_n]<='-2','-2',

IF([Month_n]<= '-9','-9'

))))

But i don't know how to trigger month seelect.

Paul Yeo

Paul Yeo

[paulyeo11]

my QVW