I need a help.
We have a sales cube with daily values.
We have a query that restricts a month (0CALMONTH) and shows the daily values for this month.
No problem, we have only to put 0CALDAY on the line and the value on the columns.
But we need also to show the values of the same days from last year.
The restricted month is july/2011.
0CALDAY is on the line, so the query shows the values for
How can we show in the same line the values for july/2011 and july/2010?
01 95,00 110,00
02 96,00 108,00
31 94,00 109,00.
Thanks in advance