Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Is there a way to have the totals from the across fields app...


John Edwards 2

Recommended Posts

Defining a whole set of Defines

Is this may better suit your needs

SET NODATA = 0

 

TABLE FILE GGSALES

SUM DOLLARS

BY REGION

BY TOTAL COMPUTE ID /I2 = 0;

BY TOTAL COMPUTE NCAT /A11 = 'Total'; AS 'CATEGORY'

ON TABLE HOLD AS TOTCOL

END

-RUN

 

TABLE FILE GGSALES

SUM DOLLARS

BY REGION

BY TOTAL COMPUTE ID /I2 = ID + 1;

BY CATEGORY

ON TABLE HOLD AS DETCOL

END

-RUN

 

TABLE FILE TOTCOL

SUM DOLLARS

BY REGION

BY ID

BY CATEGORY

ON TABLE HOLD AS RPTDATA

MORE

FILE DETCOL

END

-RUN

 

TABLE FILE RPTDATA

SUM DOLLARS/D8M AS 'Sales'

BY REGION AS 'Region'

ACROSS ID NOPRINT

ACROSS CATEGORY AS 'Category'

ON TABLE SET PAGE-NUM OFF

END

-RUN

Link to comment
Share on other sites

Yeah, I more or less did that. Morning brain is better than evening brain.

Two pulls of the data, created a synthetic Across value for the totals, combined with a More File, reported off the result. Output looks good. The biggest issue with this stuff is the Title of the columns. I like the banner value across all the columns that the Across creates, no way to do that well without the columns being in the Across.

Thank you all for the help.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...