Focal Point
[SOLVED] Moving the subtotal over one cell from the data in Excel

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/355102524

April 22, 2010, 11:36 AM
Dan_Bam
[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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
April 22, 2010, 11:51 AM
njsden
What do you mean by "one column over"?

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.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
April 22, 2010, 11:58 AM
Dan_Bam
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