Focal Point
Different way of displaying data/report.. need Across?

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

October 06, 2004, 09:04 PM
Duffy
Different 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
susannah
TABLE FILE DATA
SUM MTDACT
OVER MTDBUD
OVER MTDVAR
ACROSS ACCOUNT
END