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     Grouping row title on different line as totals
Go
New
Search
Notify
Tools
Reply
  
Grouping row title on different line as totals
 Login/Join
 
Member
posted
This code is grouping things as I need, but I want the "Total
Do I need to make a blank column in the beginning to achieve this? What are some alternatives to get it on the same line?

TABLE FILE CAR
PRINT
RETAIL_COST
SALES
COMPUTE PROFIT/D12.2 = RETAIL_COST - SALES;
BY COUNTRY NOPRINT
ON COUNTRY SUMMARIZE AS 'Total'
SUBHEAD
"SUBFOOT
" "
" "
END

We are using WebFOCUS 7.1.3.
 
Posts: 21 | Registered: September 06, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Tom,

Yes, using a DUMMY column with a subfoot and styling:

DEFINE FILE CAR
DUMMY/A1 = ' ';
END

TABLE FILE CAR
PRINT
RETAIL_COST
SALES
COMPUTE PROFIT/D12.2 = RETAIL_COST - SALES;
BY DUMMY NOPRINT
BY COUNTRY NOPRINT
-* ON COUNTRY SUMMARIZE AS 'Total'
ON DUMMY SUBFOOT
"Total <TOT.RETAIL_COST <TOT.SALES <TOT.PROFIT"
ON TABLE SET STYLE *
Style components Here
TYPE=SUBFOOT, LINE=1, ITEM=1, JUSTIFY=LEFT , STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, ITEM=2, STYLE=BOLD, POSITION = RETAIL_COST, $
TYPE=SUBFOOT, LINE=1, ITEM=3, STYLE=BOLD, POSITION = SALES $
TYPE=SUBFOOT, LINE=1, ITEM=4, STYLE=BOLD, POSITION = PROFIT, $
ENDSTYLE
END
-EXIT


Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1965 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Sort by, at least, one visible alphanumeric field.

TABLE FILE CAR
  PRINT
    RETAIL_COST
    SALES
    COMPUTE PROFIT/D12.2 = RETAIL_COST - SALES;
  BY COUNTRY NOPRINT SUMMARIZE AS 'Total'
  BY MODEL
  SUBHEAD
    " "
  SUBFOOT
    " "
    " "
END

Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
Member
posted Hide Post
Mikel, your solution was just what I needed.

Thanks for all your help.
 
Posts: 21 | Registered: September 06, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Grouping row title on different line as totals

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