Skip to Content
0
Former Member
Feb 04, 2011 at 10:53 AM

Columns pulling data between two months

25 Views

Hello,

I would like to create a variable, such that it will pull data between current month and next 11 months on webi report. This data should get generated in form of columns.

eg: If we consider today's month, then once variable is placed on report, it should generate 11 columns starting from March 2011 to Feb 2012 and corrosponding data should be visible under each column.

What is the way to achive this requirement?

*Note: Data for next 4 years is available in my database.

Regards,

Chinmay