How to create a Week filter using an Input box and variable

[pranaview]

Hi All,

I have to create a filter on my Week field which was created as a part of the Master Calendar.I know It can be done using an input box, so it would be really great if someone can shed some light on how it is done.

So, what I want is to provide user a functionality where he/she can just select a specific start week and end week number to filter the data for that range.

Any suggestion will be appreciated.

Kind Regards,

Pranav

[sasikanth]

HI,
Try to create two variables ,vWeekStart, vWeekEnd and assign them to inputs boxes .

Ex .Exp: Sum({<WeekNumber={">=$(vWeekStart) and <= $(vWeekEnd)"}>} sales)

Note: Week Number Should be like (1,2,3,4,5 ..... etc)