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