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 ?
I am not sure what you mean by 2 fields, but you can have 2 RANK functions in a report. Here is
TABLE FILE CAR
RANKED BY SEATS
RANKED BY RETAIL_COST
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.
|Powered by Social Strata|