Top N issue ?

[bob654321]

Please find the attached qvw.

1) How to arrange the order of the columns in the below format without changing the data ?

(Physician Name, Physician Specialty, Physician ID, Current Position, Total Requests, % of Grand Total, Previous Quarter Position, Previous Quarter Total Requests, % Web, CD Rate, Previous CD Rate, Most Frequently Referred To Facility)

2) For the second ranked physician Lester, the previous CD rate should be 16.7% because the numerator/denominator = 1/6 but it is showing up as 66.7% in my qvw ?

[Lisa_P · Accepted solution]

The problem with re-arranging columns is that the top N is based on the first column(1).

Also some of your expressions are referring to the column number rather than the column name.

[Brett_Bleess]

Bob, did Lisa's post help you with things?  If so, do not forget to return to your thread and use the Accept as Solution button on her post to give her credit for the help and to let the other Community Members know it did help you.  If you still need further help, please leave an update post on the thread with what you still need.

Regards,
Brett