Webi Function - Relative Month

[system]

Hi
I have a requirement.

I have Month Jan 2011, Feb 2011, Mar 2011, Apr 2011. I need to display May 2011, June 2011 using webi function.

Say for e.g. I have data from Jan 2011 to Apr 2011.
I need to project for next month data. So I need the function to display data from May 2011 to June 2011. How can I display May 2011 , June 2011 ?
We know Max ( Month) function but is there a way to display May 2011, June 2011 using variables or formula. Is there a function to display it?
How can I satisfy this requirement.
We have function for relative date but not for month.

---

istat123 (BOB member since 2012-06-19)

[system]

Hi,

Try if this reporter’s FAQ will help you:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

---

Marek Chladny (BOB member since 2003-11-27)