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 ?
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.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.