Skip to Content
0
Former Member
Oct 21, 2005 at 09:36 PM

Current and Prior MTD and YTD Sales Query

84 Views

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