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     [RESOLVED] Across-Total - To column order
Go
New
Search
Notify
Tools
Reply
  
[RESOLVED] Across-Total - To column order
 Login/Join
 
Member
posted
Hi,

Is there any way that bring the across-total first and then across fields

For Example

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ACROSS MODEL
ON TABLE ROW-TOTAL
END

in the above case ROW-TOTAL prints as last column
but I want ROW-TOTAL First followed by the across field values

Any suggestion?

Thanks

This message has been edited. Last edited by: Satya Dach,


WebFOCUS 8.1
Windows, PPT
 
Posts: 19 | Registered: June 26, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hi Satya and welcome to the Forum.
This should do the trick:
  
TABLE FILE CAR
SUM DEALER_COST AS TOTAL
BY COUNTRY 
SUM DEALER_COST
ACROSS SEATS
BY COUNTRY
ON TABLE SET ACROSSTITLE SIDE
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1936 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Hi,

Thanks for the respond, in my code I can't use multi verb because it is a compound report and will impacts other reports. Is there any direct way like we use for subtotal like sub-total above?

Thanks


WebFOCUS 8.1
Windows, PPT
 
Posts: 19 | Registered: June 26, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
A way could be to create the across-column total then hold the result, create the across fields and hold the result, then match both files together.

Such as:
TABLE FILE CAR
SUM DEALER_COST AS 'DEALER_COST_TOT'
BY COUNTRY
ON TABLE HOLD AS TOT FORMAT FOCUS
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
BY SEATS
ON TABLE HOLD AS DET FORMAT FOCUS
END
-RUN

MATCH FILE TOT
SUM DEALER_COST_TOT
BY COUNTRY
RUN
FILE DET
PRINT SEATS
      DEALER_COST
BY COUNTRY
AFTER MATCH HOLD AS RESULT OLD-OR-NEW
END
-RUN

TABLE FILE RESULT
SUM DEALER_COST
BY COUNTRY
BY DEALER_COST_TOT
ACROSS SEATS
END
-RUN


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: 2233 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Thanks got it, working as expected


WebFOCUS 8.1
Windows, PPT
 
Posts: 19 | Registered: June 26, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hi Satya,
Please change the title with [RESOLVED] in prefix.
So that if anyone has the same kind of issue, then they will follow the same steps to get it fixed.

Have a nice day...
Regards,
Suresh


WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA
 
Posts: 47 | Location: Bengaluru, India | Registered: December 04, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [RESOLVED] Across-Total - To column order

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