Skip to Content
0
Jan 08, 2009 at 04:58 PM

Providing Current & Previous year numbers

11 Views

I'm sure this information is out there, but my searches have not found anything. Can anyone point me to some documentation or provide input on how to best do this type of reporting in BEx Query Designer? Here is the results we want in the simplest form:

Week CUR PRV

01/2009 100 200

02/2009 200 150

But here is what we are getting:

Week CUR PRV

01/2008 - 200

01/2009 100 -

02/2008 - 150

02/2009 200 -

Currently we prompt for a current week/year (i.e. 02/2009). Then in a user exit we calculate a range for current (01/2009 to 02/2009) and previous (01/2008 to 02/2008). The range is then used on the report in the key figure calculation. Any ideas on how we can design this?

Thanks,

Chris