Is there any way that bring the across-total first and then across fields
TABLE FILE CAR
ON TABLE ROW-TOTAL
in the above case ROW-TOTAL prints as last column
but I want ROW-TOTAL First followed by the across field values
ThanksThis message has been edited. Last edited by: Satya Dach,
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
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
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?
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.
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 126.96.36.199M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
Thanks got it, working as expected
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...
WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA
|Powered by Social Strata|