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