I want to build a report to compare this year turnover with last year turnover. This comes from 1 table and I do not know how to create this comparison without getting duplicates. I have made 2 dataproviders (this year and last year), but because we have some overlapping months for some collections I get double figures.
For example this is what I want but I will end up getting other number for Last Year.
This Year Last Year
MM-YYYY NOV MM-YYYY NOV
2006 - 12 2,752.50 2005 - 12 1,372.95
2007 - 01 1,684.60 2006 - 01 1,959.85
2007 - 12 1,809.26 2006 - 12 2,752.50
2008 - 01 972.37 2007 - 01 1,684.60
HI,
If you can separate month from year,
you can built crosstab table with column of months and rows of year, and then to show values in it, just by one data provider. I think this is the very simple way to show data.
For example:
2006 2007
12 135 138
How can we suggest when you did not show us what data is in which DP? How many years of data are you pulling in the report …? And in your expected results I am seeing 4 years…?
DataProvider 1(this year) takes the turnovers by deliverycalendar months 2006-12 up to including 2008-01.
Dataprovider 2(last year) takes the turnovers by deliverycalendar months 2005-12 up to including 2007-01.
Because I cannot link the deliverycalendermonths of the 2 DP’s, I only take the month without the year. But then I get that the Last year turnovers of december and january are added up, meaning 2005-12 and 2006-12 is summed up and the same for 2006-01 and 2007-01.
As you can see in the attachment, figures appearing under ‘Correct’ are accurate, but Last Year are not for the months december and january. All other months are fine.
me to BOB,
(BOB member since 2004-06-06)