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     Different way of displaying data/report.. need Across?
Go
New
Search
Notify
Tools
Reply
  
Different way of displaying data/report.. need Across?
 Login/Join
 
Member
posted
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.
 
Posts: 8 | Location: Texas | Registered: May 23, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
TABLE FILE DATA
SUM MTDACT
OVER MTDBUD
OVER MTDVAR
ACROSS ACCOUNT
END
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Different way of displaying data/report.. need Across?

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