Skip to Content
0
Former Member
Dec 08, 2011 at 04:59 PM

Comparing the Current year day to the Prior year day data in webi

354 Views

Hello Everyone,

I am trying to create a report in webi which will compare the last year sales to current year sales on day.

i.e 3rd Monday in Jan2010 = 3rd Monday in Jan 2011.

I have create a variable prior year ' =RelativeDate([Calendar day];-(52*7))' Which tells me which day was monday last year.

Claendar Year Prior Year Current year Sales Prior year sales

12/1/2010 12/2/2009 3000

12/2/2010 12/3/2009 5000

12/3/2010 12/4/2009 3000

12/1/2011 12/2/2010 2000

12/2/2011 12/3/2010 4000

But i need the current year sales and the prior year sales to be on the same row.

ex: 12/1/2011 12/2/2010 2000 5000

Is there any way to do that?

Thanks