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     Rank function by two fields ?
Go
New
Search
Notify
Tools
Reply
  
Rank function by two fields ?
 Login/Join
 
Gold member
posted
I found that it is worked when using RANKED with one field. But, how to the RANKED function with two fields ?

Can it work with two fields or other function can solve it ?
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I am not sure what you mean by 2 fields, but you can have 2 RANK functions in a report. Here is
one way..
TABLE FILE CAR
PRINT MODEL
RANKED BY SEATS
RANKED BY RETAIL_COST
END
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Sorry about that I am not clear out the problem. I used the RANKED function by ONE field, but I found that maybe two or more records will be ranked at the same level.

I would like to rank the data by TWO or MORE fields.
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Rank function by two fields ?

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