I did some searching in the forum but was unable to find exactly what I am looking for.

I would like to have multiple subtotals in an across. For example A report that shows an amount for each month in a year across then have a subtotal at each quarter and a total at year end. In the following string the Qx value would be a subtotal of the previous 3 columns and the YearTotal column would be the sum of all non-Qx columns.

J F M Q1 A M J Q2 J A S Q3 O N D Q4 YearTotal

Thanks in advance.

This message has been edited. Last edited by: <Kathryn Henning>,

TABLE FILE CENTURYSALES
SUM RETURNS
ACROSS QUARTER
ACROSS MONTH SUB-TOTAL

BY PLANTNAME
END

You also get the row total with a subtotal.

This reply gave us exactly what we needed.

Thank you.