Using multiple sheets with different Dates...Error

[morenasm]

Hi Guys

I hope someone can help me. 

I am having trouble with my data. I have a QVD file that i am uploading with sales data and then i have an Excell file im uploading for all the Orders placed. Now both these files have their own relevant dates. I cant seem to get them working. It shows the dates when i build the report but when i select week or month or any time period at adss all the 'QTY Sold' Togther.

[Calendar]:
LOAD Distinct
Year([Cal Date]) as [Year],
Num(Month([Cal Date]),'00') as [Month],
Year([Cal Date]) * 100 + Month([Cal Date]) as [Num Period],
Dual(Monthname([Cal Date]),Year([Cal Date]) * 100 + Month([Cal Date])) as [Period],
MonthName(Date([Cal Date],'DD/MM/YYYY')) as [Year Month];
LOAD
$(vCalStartDate) + IterNo() - 1 as [Cal Date]
AutoGenerate (1)
WHILE $(vCalStartDate) + IterNo() - 1 < $(vCalEndDate);

[Lisa_P]

What does your data model look like ?