Expanded Functionality With BY TOTAL and ACROSS

Example: Using BY TOTAL on a Calculated Value With an ACROSS Phrase

The following request creates the calculated value PROFIT and uses it in the BY TOTAL phrase. The request also has an ACROSS RATING phrase.

TABLE FILE MOVIES
SUM LISTPR WHOLESALEPR
COMPUTE 
PROFIT = LISTPR - WHOLESALEPR; 
BY CATEGORY
BY TOTAL PROFIT
ACROSS RATING
WHERE  RATING NE 'NR' OR 'R'
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *GRID = OFF,$
ENDSTYLE
END

The output is shown in the following image.