SET EXPANDBYROW = ON TABLE FILE BSH SUM BSH.SEG01.COUNT AS 'Totals' BY LOWEST BSH.SEG01.TERRITORY_NAME BY LOWEST BSH.SEG01.MARKET BY LOWEST BSH.SEG01.REGION_NAME BY LOWEST BSH.SEG01.CALLERBRANCH ON BSH.SEG01.TERRITORY_NAME RECOMPUTE AS '*TOTAL' ON BSH.SEG01.MARKET RECOMPUTE AS '*TOTAL BSH.SEG01.MARKET' ON BSH.SEG01.REGION_NAME RECOMPUTE AS '*TOTAL BSH.SEG01.REGION_NAME' ON TABLE SUBHEAD "Territory/Market/Region/Branch Totals" WHERE TERRITORY_NAME EQ '&TN'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SUMMARIZE BSH.SEG01.COUNT AS 'TOTAL' ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ TYPE=DATA, COLUMN=N4, FOCEXEC=callerbranchcnt, $ TYPE=TABHEADING, LINE=1, JUSTIFY=LEFT, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=11, $ TYPE=SUBTOTAL, BY=1, COLOR='WHITE', BACKCOLOR='TEAL', $ TYPE=SUBTOTAL, BY=2, COLOR='WHITE', BACKCOLOR=RGB(102 102 153), $ TYPE=SUBTOTAL, BY=3, COLOR='WHITE', BACKCOLOR='OLIVE', $ TYPE=SUBTOTAL, BY=6, COLOR='WHITE', BACKCOLOR='BLUE', $ ENDSTYLE END
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |