[SOLVED] Moving the subtotal over one cell from the data in Excel
I am trying to do something that I would think is simple, but am having a great deal of difficulty. In an Excel report, I would like the subtotal amount to appear one column over instead of right under the data. Is there a simple way to do this?This message has been edited. Last edited by: Kerry,
Webfocus 7.65 UNIX
April 22, 2010, 11:50 AM
GinnyJakes
I think you'll have to use SUBFOOT and spot markers to align your subtotal under the column you want.
If what you need is the subtotal to appear *before* the group of data to which it corresponds then you cannot accomplish with SUBTOTAL. Only SUBHEAD would help you there.
I haven't worked much with spot markers. Could you please give me a simple example.
Webfocus 7.65 UNIX
April 22, 2010, 12:04 PM
Francis Mariani
TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE SUBFOOT
"<+0> <+0> <ST.SALES"
ON TABLE SET STYLE *
TYPE=TABFOOTING, HEADALIGN=BODY, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
<+0> is a spot marker, it works in conjunction with headalign.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 22, 2010, 02:00 PM
Dan_Bam
Can this be done for a subhead? What would the stylesheet entry be?
Webfocus 7.65 UNIX
April 22, 2010, 02:06 PM
Dan_Bam
I did get it working....Thanks to all of you for your help!
Webfocus 7.65 UNIX
April 22, 2010, 03:41 PM
Francis Mariani
I'm happy you tried and succeeded.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server