Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Field in Subtotal but not Grand Total

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Field in Subtotal but not Grand Total
 Login/Join
 
.eric
Platinum Member
posted
Is there a way to show a field in the subtotal line but not the grand total line?

Basically I have a purchase report that is broken down into categories. The field is a percent to total field, so every subtotal would be a percent to total of the grand total. So say category A B and C are all 33.33% the grand total should always be 100%, basically the users don't want to see the 100%. I tried specifiying the fields in the ON TABLE SUBTOTAL line and excluding them from the ON TABLE TOTAL line but it shows on the grand total line anyway.

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
 
Posts: 153 | Location: Chicago, IL | Registered: February 24, 2006Report This Post
.eric
Platinum Member
posted Hide Post
Here is an example using the car file:

TABLE FILE CAR
SUM DEALER_COST
COMPUTE PCT_COST/D12.2% = DEALER_COST / TOT.DEALER_COST * 100;
BY CAR
BY MODEL
ON TABLE HOLD
END

TABLE FILE HOLD
PRINT DEALER_COST PCT_COST
BY CAR
BY MODEL
ON CAR SUB-TOTAL DEALER_COST PCT_COST
ON TABLE COLUMN-TOTAL DEALER_COST
END

So basically I want PCT_COST in the sub-total line and not in the column-total line.

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
 
Posts: 153 | Location: Chicago, IL | Registered: February 24, 2006Report This Post
OPALTOSH
Platinum Member
posted Hide Post
TABLE FILE CAR
SUM DEALER_COST
COMPUTE PCT_COST/D12.2% = DEALER_COST / TOT.DEALER_COST * 100;
BY CAR
BY MODEL
ON TABLE HOLD
END
DEFINE FILE HOLD
DUMMY/A1=' ';
END
TABLE FILE HOLD
PRINT DEALER_COST PCT_COST
BY DUMMY NOPRINT
BY CAR
BY MODEL
ON CAR SUBFOOT
"ON DUMMY SUBFOOT
"ON TABLE NOTOTAL
END

You can then format the Subfoots using a style sheet so that they look like sub totals. You also have more flexibility about what else you might want to display in the subfoot.
 
Posts: 140 | Location: Adelaide South Australia | Registered: October 27, 2006Report This Post
.eric
Platinum Member
posted Hide Post
I still need column totals though, the subtotal line isn't the problem, it's the very last total line (grand totals) where I need to exclude the PCT_COST field.


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
 
Posts: 153 | Location: Chicago, IL | Registered: February 24, 2006Report This Post
KevinG
Platinum Member
posted Hide Post
Eric,

Maybe not the ultimate solution, but you could set the "Color" of that item in the StyleSheet to be the same color as the background of your Grand Total line. This will effectively not display that field (although it is really still there.)

Kevin


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Eric,

Have you tried:

ON TABLE SUMMARIZE DEALER_COST AS 'Total '
ON TABLE NOTOTAL

Opal had :

"ON DUMMY SUBFOOT
"ON TABLE NOTOTAL

incorrectly...

OR

U could try:

See where Opal did a DEFINE for DUMMY


ON DUMMY SUBFOOT
"Summary <TOT.DEALER_COST"


then a stylesheet:

TYPE=SUBFOOT, LINE=1, ITEM=1, JUSTIFY=LEFT , STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, ITEM=2, STYLE=BOLD, POSITION = DEALER_COST, $

Tom

This message has been edited. Last edited by: Tom Flynn,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
.eric
Platinum Member
posted Hide Post
Tom-
I already tried

ON TABLE SUMMARIZE DEALER_COST AS 'Total '
ON TABLE NOTOTAL

If you look at my code I had the same thing but with RECOMPUTE instead of SUMMARIZE. And it still adds that field into the grand totals line. Also If I add the ON TABLE NOTOTAL it removes the grand total line...

I'm also trying to avoid using subfoots because this particular report has about 15 or so fields and it might get a little messy.

I guess I can use Kevin's idea if there is nothing else.

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
 
Posts: 153 | Location: Chicago, IL | Registered: February 24, 2006Report This Post
Tom Flynn
Expert
posted Hide Post
Eric,

I did look at your code. Still don't see a

RECOMPUTE

but, maybe that's just me...


Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
.eric
Platinum Member
posted Hide Post
Sorry, I had to look it over myself, I have a column-total there instead.

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
 
Posts: 153 | Location: Chicago, IL | Registered: February 24, 2006Report This Post
OPALTOSH
Platinum Member
posted Hide Post
Eric,
My original code was the same as Tom's but it did not copy into the post correctly.

I don't think ypu can do whatyou want to do without a subfoot.
 
Posts: 140 | Location: Adelaide South Australia | Registered: October 27, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Field in Subtotal but not Grand Total

Copyright © 1996-2020 Information Builders