Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if i select the 2013 jan mean i want to show next 21 month sales values in line chart
can you attach a screenshot of your script or attach sample source file
Dear Jonathan Penulier,
SupplyPlan:
LOAD SupplyID,
ChildID,
//LITM,
//BusinessUnitID,
// MarketID,
//ProductGroupID,
// SourceID,
//month,
//year,
//ForMonth,
//ForYear,
Month(AddMonths(Today(),21)) as TransactionDate,( this is used in master calender)
Submitted,
GroupID;
SQL SELECT *
FROM "Genesis_Reports".dbo."tbl_supply";
Left join(SupplyPlan)
SupplyPlanDetails:
LOAD ID,
SupplyID,
//LITM,
//Year,
// Month,
OpeningStock,
ClosingStock,
StockCoverDays,
PrimarySales,
SecondarySales,
//FCL,
Palletized;
SQL SELECT *
FROM "Genesis_Reports".dbo."tbl_supplydetails";
Can you attached your qvw file,
at this point, I wouldn't want to touch your script, as i believe we have moved away from your original post, that is to Sum Sales in a Line based on a 21 month range. earlier, ive given you an example,
Example: StartDate = Today()
EndDate = Month(AddMonths(Today(),21))
In this case, StartDate can be your selected month(you can pull this from your Master Calendar).
You only need to add 21 months from your StartDate , and to be able to use these Date Range(StartDate and EndDate) to compute your Sales.