Skip to Content
0
Former Member
Apr 01, 2013 at 08:45 PM

Data between months range

21 Views

Hi,

i have a report were end users selects "months starting" from and "months Ending" as prompts and year as another prompts.I need to show the report containing data between the user selected month prompts.I have the revenue values seperate for january ,feb,march, till..dec

Ex: if the user gives the months prompts as Months Starting =3 , Months Ending =8 and year=2012.I need to get the data for year 2012 between march and august.

i.e. march+April+May+June+July + August.

2.if the user selects the prompts as Months Starting =9 and Months Ending =12 .I need to get the data between sep and dec.

ie. sep+oct+nov+dec.

please let me know how to achieve this in deski report