[solved] Column heading wanted for ACROSS NOPRINT Across-total

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/930103932

September 14, 2009, 04:20 PM

Hua

[solved] Column heading wanted for ACROSS NOPRINT Across-total

Hello,

I have re-sequence the columns appear on the report and don't want to display the sequences but like to display the "TOTAL" for across-total. Any ideal?

DEFINE FILE CAR
order_of_importance/I1=
IF COUNTRY EQ 'W GERMANY' THEN 1 ELSE
IF COUNTRY EQ 'JAPAN' THEN 2 ELSE
IF COUNTRY EQ 'ITALY' THEN 3 ELSE 9;
END
TABLE FILE CAR
SUM
     'CAR.BODY.SALES'
BY 'CAR.COMP.CAR'
ACROSS 'CAR.ORIGIN.order_of_importance' NOPRINT ACROSS-TOTAL
ACROSS 'CAR.ORIGIN.COUNTRY' AS ''
END

Thanks.

Hua

This message has been edited. Last edited by: Hua,

September 14, 2009, 05:21 PM

GinnyJakes

DEFINE FILE CAR
order_of_importance/I1=
IF COUNTRY EQ 'W GERMANY' THEN 1 ELSE
IF COUNTRY EQ 'JAPAN' THEN 2 ELSE
IF COUNTRY EQ 'ITALY' THEN 3 ELSE 9;
END
TABLE FILE CAR
SUM
     'CAR.BODY.SALES'
BY 'CAR.COMP.CAR'
ACROSS 'CAR.ORIGIN.order_of_importance' NOPRINT 
ACROSS 'CAR.ORIGIN.COUNTRY' AS '' ROW-TOTAL
END

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google