I have a three tables and want to display the range sum of sales from specific festival. For example two days sales sum from diwali festival. Sample Application is attached Pls Help !!!!!!!!!!!!!!!!!!
Festival_Table:
FDate, Festival;
Nokia Sales:
LOAD Date,
"BB_Price",
BillNo,
Category,
Coll,
Discount,
"Discount_Per",
DP,
FM,
"FM_Per",
Model_No,
Qty,
SCode
From D:\QLick View Files\QVD\NOKIA_SALES.qvd(qvd);
Calender:
TempCalendar:
Set Soft_Date=Num('01/01/2002');
Set Curr_Date=Today();
LOAD
$(Soft_Date)+IterNo()-1 AS Num,
Date($(Soft_Date)+IterNo()-1) AS Date
AUTOGENERATE 1 WHILE $(Soft_Date)+IterNo()-1 <= $(Curr_Date);
TempCalendar1:
Load Date,
Year(Date) As Year,
Month(Date) As Month,
Day(Date) As Day,
Month(Date)&'-'&Day(Date) As Day_Month
Resident TempCalendar;
Drop table TempCalendar;