Focal Point
[SOLVED] Subtotal in an Across

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8637035966

March 10, 2014, 02:04 PM
Frank Cole
[SOLVED] Subtotal in an Across
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>,


WebFocus 8.009
Windows 2008R2 x64
HTML, PDF, AHTML, Excel
March 10, 2014, 04:46 PM
GCohen
TABLE FILE CENTURYSALES
SUM RETURNS
ACROSS QUARTER
ACROSS MONTH SUB-TOTAL

BY PLANTNAME
END

You also get the row total with a subtotal.


Release 7.6.9
Windows
HTML
March 11, 2014, 09:07 AM
Frank Cole
This reply gave us exactly what we needed.

Thank you.


WebFocus 8.009
Windows 2008R2 x64
HTML, PDF, AHTML, Excel