Hi,
We have a billing infocube where we want to see the current and prior year sales by calmonth side by side.
2004/01 $10,000 2005/01 $25,000
2004/02 $15,000 2005/02 $45,000
....
....
We have everything in the billing cube to accomplish this, meaning calmonth and the net value. How do you create the query to accomplish this side by side comparison? It's simple enough to just show one single column of calmonth and then the net value for that month, but we want the side-by-side comparison.
Can someon elaborate on how to accomplish this?
Cheers,
Mike