Focal Point
Rank function by two fields ?

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

January 08, 2005, 01:47 PM
Ringo
Rank function by two fields ?
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 ?
January 09, 2005, 03:30 PM
GCohen
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
January 10, 2005, 12:02 PM
Ringo
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.