Button to select one or all

[ronaldwang]

I have a dimension called month, where “Jan, Feb, Mar…Dec” is stored, where I want to give use to select one of the months (and the default will be always current month). On top of that I also want to give the user to select either current month only or YTD (which means to select all the previous months). Any idea on how to implement this? Many thanks

[prat1507 · Accepted solution]

Hi Please use this

Tab1:

LOAD * inline [

Months

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];

Let v_currMth=Month(Today());

Tab2:

LOAD * inline [

Status, Months

Curr, $(v_currMth)

];

Tab3:

Load 'YTD' as Status,* Resident Tab1

where date(month(date#(Months,'MMM')) )<= date(Month(Today()));

Create a listbox with Status and use.

Regards
Pratyush

[ronaldwang]

thanks Pratyush, it is nice