![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Member |
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! JayThis message has been edited. Last edited by: Jay Ervin, WebFOCUS 8.1/8.2, Windows 10/Server 2012 | ||
|
Virtuoso |
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 | |||
|
Member |
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 | |||
|
Member |
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 | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|