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

[John Edwards 2]

Is there a way to have the totals from the across fields appear first instead of last, i.e., on the left side of the table instead of the right

I know I can rewrite the entire report to do the fields individually, I just want to make sure Im not missing a magical setting.

[Martin Yergeau]

Nop

Except if you use the multi-verb then the total will be at left

Or if you manually create an across-total column that you place yourself as the first one : meaning create a dummy across value that will become the first one.

[John Edwards 2]

Yeah, thats what I figured. But the multi-verb doesnt create an event set of titles across the top, so it looks hokey. Ill need to create a full set of Define fields to roll this out. Thanks for the word.

[Martin Yergeau]

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

[John Edwards 2]

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.

[Martin Yergeau]

Can you mimics/sample what you are looking for