When the SUBTOTAL, SUB-TOTAL, SUMMARIZE, or RECOMPUTE commands are used with burst reports, the WebFOCUS Reporting Server automatically suppresses the grand total. For example, the following code

TABLE FILE CENTINV
SUM QTY_IN_STOCK
BY PRODCAT SUBTOTAL 
BY PRODTYPE BY PRODNAME
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END

might produce the following Excel report for a burst value of PRODCAT (Product Category). The grand total for each product type is suppressed, and the quantity in stock values are only totaled by product category.

When a report with ON TABLE COLUMN-TOTAL is burst, a column total is created for each burst value. For example, the following code

TABLE FILE CENTINV
SUM QTY_IN_STOCK
BY PRODCAT
BY PRODTYPE SUBTOTAL BY PRODNAME 
ON TABLE PCHOLD FORMAT EXL2K FORMULA 
ON TABLE COLUMN-TOTAL 
END

might produce the following Excel report for a burst value of PRODCAT (Product Category). A column total is created for each product type (for example, Analog), and the quantity in stock values are totaled by product category.