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     columns following an ACROSS
Go
New
Search
Notify
Tools
Reply
  
columns following an ACROSS
 Login/Join
 
<Lisa M>
posted
I need to create a report which includes an ACROSS (# quotes by month, total #-using row total), but which also needs to display additional information in the same BY (total sales $, average $ per month).

Here's what I'm looking to output:

____Jan__Feb...Dec__Total#__Total$__Ave$
2004_5___10____5____20_____$100____$5
2003_4___11____10___25_____$100____$4

I'm ok with creating the BY and ACROSS, but can't get any other columns to be in the same BY but not in the ACROSS. I'm looking to avoid defining fields for each month (too slow) or creating HOLD files.

Any suggestions would be greatly appreciated!
 
Reply With QuoteReport This Post
Master
posted Hide Post
Hi Lisa,

You can code COMPUTE commands after your ACROSS phrase. This will get you columns after your BY/ACROSS matrix.

For example:

  <br /><br />TABLE FILE CAR<br />SUM    RCOST     NOPRINT<br />       CNT.RCOST NOPRINT<br />       AVE.RCOST NOPRINT<br />BY     CAR<br />SUM    RCOST     AS ''<br />BY     CAR<br />ACROSS COUNTRY   AS 'Country'<br />COMPUTE TOT_RCOST/D7 = C1;  AS 'Total Rcost'<br />COMPUTE CNT_RCOST/D7 = C2;  AS '# OF Cars'<br />COMPUTE AVG_RCOST/D7 = C3;  AS 'Avg Rcost'<br />END
Running this TABLE will give you three calculated columns to the right of the matrix.

It is kind of hard to do a meaningful ACROSS report against the CAR database, but you should get the idea from this example.

Regards,
Dave
 
Posts: 780 | Registered: April 23, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     columns following an ACROSS

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