Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Subtotal in an Across
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Subtotal in an Across
 Login/Join
 
Member
posted
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
 
Posts: 8 | Registered: February 26, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
Member
posted Hide Post
This reply gave us exactly what we needed.

Thank you.


WebFocus 8.009
Windows 2008R2 x64
HTML, PDF, AHTML, Excel
 
Posts: 8 | Registered: February 26, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Subtotal in an Across

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.