October 06, 2004, 09:04 PM
DuffyDifferent way of displaying data/report.. need Across?
TABLE FILE DATA
SUM MTDACT
MTDBUD
MTDVAR
BY ACCOUNT
END
-*
Report is displayed:
ACCOUNT MTDACT MTDBUD MTDVAR
Net Revenue 9999 8888 7777
Net Expenses 6666 5555 4444
Wages 3333 2222 1111
Now, I need this report to display in this order:
Net Revenue Net Expenses Wages
MTDACT 9999 6666 3333
MTDBUD 8888 5555 2222
MTDVAR 7777 4444 1111
I tried to use ACROSS, but still not able to produce results.
Anybody has any ideas? Thanks.
October 06, 2004, 10:34 PM
susannahTABLE FILE DATA
SUM MTDACT
OVER MTDBUD
OVER MTDVAR
ACROSS ACCOUNT
END