Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Total Multiple BY Fields Separately
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Total Multiple BY Fields Separately
 Login/Join
 
Member
posted
Hello! I have a table with two BY fields. Is there a way to get a total by the second field irrespective to the first? For instance:

TABLE FILE CAR

SUM SALES
BY COUNTRY
BY BODYTYPE
ON TABLE PCHOLD FORMAT HTML
ON COUNTRY SUMMARIZE
ON TABLE SUMMARIZE

END

Is there a way that I can get totals by BODYTYPE without considering COUNTRY? Or will I need to append a second table to the end of it? I'm envisioning 5 new lines somewhere around the grand total (Sedan, Coupe, etc.), with their respective sums.

Thanks!
Jay

This message has been edited. Last edited by: Jay Ervin,


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 10 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Look at my answer at 1:46 pm from below post
SubTotal on multiple sort fields
This can be one way but I don't know all your requirements


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2093 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by MartinY:
Look at my answer at 1:46 pm from below post
SubTotal on multiple sort fields
This can be one way but I don't know all your requirements


I had tried a hold file technique like this, but I couldn't get it to work. Reading yours, I was missing both the blanking of the unnecessary field and the ranking to organize the lines. I can definitely work with this!

One last (hopefully quick) question... any suggestions on getting the word "COUNTRY" out of the subtotal lines (*TOTAL COUNTRY ENGLAND)?


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 10 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
Member
posted Hide Post
Nevermind, I figured it out! I just added AS names to my summarize lines.

Thanks again for your help!


WebFOCUS 8.1/8.2, Windows 10/Server 2012
 
Posts: 10 | Location: Baltimore, MD | Registered: April 30, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Total Multiple BY Fields Separately

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.