Previous 5 Months data display on selection of a particular month

[#1]

Hi Guys,

I have a requirement in one of my chart.

I have a MonthYear list box which will display month and year in the format... Apr-13, Mar-13

I have a bar chart t to display a revenue based on Month.

The requirement is when the user select a month the bar chart should display the selected month and selected month - 5 month data.

For example Apr13 is selected,bar chart sholud display apr-13,Mar-13, Feb 13--Nov -12 data.

How Can I do that? I have worked on this if the date selection is made from the calender object.

Please suggest ur ideas if anybody has worked on this requirement.

Any help would be greatly appreciated

Thanks and Regards,

Praveena

[Anonymous]

Set up two variables, StartDate and EndDate then use these in an expression. Something like:

StartDate    =MonthStart(AddMonths(Today(),-5)

EndDate     =Today()    ..... or MonthEnd(Today())

sum({<Date={'>=StartDate <=EndDate'}>} Value)

Jonathan

[#3]

Hi Jonbroghavone,

I tried this.

But this does not work for me.

I am attaching the application. I would be greatful if you can help me

MonthYear list box the selection box.

I have two triggers to set the vaibales vStart and vEnd at the document properties-->field event trigger-->MonthYear

[#4]

Hi Jonbroghavone,

I tried this.

But this does not work for me.

I am attaching the application. I would be greatful if you can help me

MonthYear list box the selection box.

I have two triggers to set the vaibales vStart and vEnd at the document properties-->field event trigger-->MonthYear

[er_mohit]

SEE attached file