Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
SEE attached file