November 10, 2006, 12:02 PM
Tom BrittnacherGrouping row title on different line as totals
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.
November 10, 2006, 12:18 PM
Tom FlynnTom,
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
November 10, 2006, 12:55 PM
MikelSort 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
November 10, 2006, 01:40 PM
Tom BrittnacherMikel, your solution was just what I needed.
Thanks for all your help.