[SOLVED] Displaying BY All the way down the column

Focal Point

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

March 05, 2009, 09:38 AM

MattC

[SOLVED] Displaying BY All the way down the column

Is there a way to display my 2 BY's all the way down the column?

BY MAJOR_CATEGORY_DES
BY FAMILY_CATEGRY_DES

Thanks.

 TABLE FILE FAM_CAT_PRC
SUM
	  STD_PRC
ACROSS SITE_NUM AS ''
BY FAMILY_CAT_ID NOPRINT
BY MAJOR_CATEGORY_DES 
BY FAMILY_CATEGRY_DES 
BY LINK_ID
BY PROD_DES
WHERE MAJOR_CATEGORY_DES = &MAJOR_CAT_DES.(OR(FIND MAJOR_CATEGORY_DES IN MAJOR_CATEGORY)).MAJOR_CAT_DES.;
ON TABLE PCHOLD FORMAT EXL2K

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

March 05, 2009, 09:55 AM

GinnyJakes

SET BYDISPLAY=ON

However, that will display all of them.

You can also do a multi-verb request and sum the two you want to repeat then do the across.

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