Skip to Content
0
Feb 09, 2009 at 09:21 PM

BI Query Monthly (this year and last year) vs YTD (this year and last year)

34 Views

I have a query requirement in BI to create a Query which will give me

Sales Monthly (this year and last) vs YTD Sales (this year and last).

Here is an example of how the query would look:

01/2007 01/2008 02/2007 02/2008 03/2007 03/2008 YTD 2007 YTD 2008

Above would represent CKF's by month and YTD with Text Variables.

Is this possible? Obviously my problem is the number of columns that I would need, since I would not always be reporting on the same month(s). Any suggestions (if this is possible).

Thanks