I have a report that I would like to keep track of the running total by class by month.

When I wrote the code,

TABLE FILE CLASS_SALES
SUM
     SALES_AMT
     COMPUTE RUN_SALES/D12.2 = SALES_AMT + RUN_SALES;
BY CLASS_ID
BY MONTH_ID
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END

This just continued on and did not break on every class_id.

How can I reset the running total when the class_id changes.

Thanks,
Joel

This message has been edited. Last edited by: Joel,

The running total as created in your compute would not break by class ID. You would have to manually create the break. Something like:

COMPUTE RUN_SALES/D12.2=IF CLASS_ID EQ LAST CLASS_ID THEN SALES_AMT + RUN_SALES ELSE SALES_AMT;

Thanks Darin!