TABLE FILE SALES
SUM
-* COMPUTE DiscountPercentageOfSales/D12.2% = Disc / NetGrossSales * 100; AS 'CurrentYear'
-* COMPUTE DiscountPercentageOfCompSales/D12.2% = DiscComp/ NetGrossComp * 100; AS 'LastYear'
COMPUTE Disc/D12.2 = ABS(ItemDiscountAmount) + ABS( CheckDiscountAmount );
COMPUTE DiscComp/D12.2 = ABS(CompItemDiscountAmount) + ABS( CompCheckDiscountAmount );
COMPUTE DiscountPercentageOfSales/D12.2% = (Disc / SALES.SALES.GrossSalesAmount) * 100; AS 'CurrentYear'
COMPUTE DiscountPercentageOfCompSales/D12.2% = DiscComp/ SALES.SALES.CompGrossSalesAmount * 100; AS 'LastYear'
BY SALES.CALENDAR.DayNumberInWeek NOPRINT
BY SALES.CALENDAR.BusinessDate
WHERE SALES.SITECONCEPT.SiteConceptNumber EQ &Concept_No;
WHERE SALES.SALESCATEGORY.SalesCategoryID IN (&Sales_Cat_ID);
WHERE SALES.DAYPARTTIME.DaypartID IN (&Daypart_ID);
WHERE SALES.DEPARTMENT.DepartmentNumber IN (&Dept_No);
WHERE SALES.LOCATION.LocationID IN (&Location);
WHERE ( SALES.SALES.BusinessDate GE '&Start_Date' ) AND ( SALES.SALES.BusinessDate LE '&End_Date' );
WHERE SALES.SALESCATEGORY.CategoryExclusion NE ('Exclude');
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MYSLS FORMAT ALPHA
END
-RUN

TABLE FILE MYSLS
PRINT *
ON TABLE PCHOLD FORMAT HTML
-RUN
-EXIT

?FF ROLLING_DATES

?FF MYSLS
-*-EXIT

JOIN INNER ROLLING_DATES.ROLLING_.BusinessDate IN ROLLING_DATES TO MULTIPLE MYSLS.MYSLS.BusinessDate IN MYSLS TAG J1 AS J1
END

GRAPH FILE ROLLING_DATES
SUM
J1.MYSLS.CURRENTYEAR AS 'Current Year'
J1.MYSLS.LASTYEAR AS 'Last Year'
-* COMPUTE T/D12.2 = 4.30; AS 'Target'
BY ROLLING_DATES.ROLLING_.GroupBy AS 'Date';
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
setTextRotation(getY1Label(),0);
setTextRotation(getO1Label(),0);

*END
INCLUDE=IBFS:/WFC/Repository/Styles_and_Images/RosnetRpt.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setFillColor(getSeries(0),new Color(255,0,0));
setFillColor(getSeries(1),new Color(160,160,160));
setFillColor(getSeries(2),new Color(0,0,0));
setDisplay(getX1Title(),true);
setTextString(getYTitle(),"Discount as % of Sales");

*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"blaProperties": {
"seriesLayout": "absolute"
},
"agnosticSettings": {
"chartTypeFullName": "Line_Absolute"
}
*END
ENDSTYLE
END
-RUN

This message has been edited. Last edited by: FP Mod Chuck,

Nihitha

Using SUM will always display the cumulative value. PRINT will do individual values but I think the chart will be very messy. Maybe consider doing a drill down to a report with the individual values.