I was wondering if anyone could be of assistance. I would like to rank data using set analysis.
Load * Inline [
Doctor, DIagnosis, Treatement Intent, Cost
John Test, Breast Cancer, Curative, 20000
John Test, Colon Cancer, Curative, 25000
John Test, Breast Cancer, Curative, 25000
Ben One, Prostate Cancer, Palliative - Symptom Control, 15500
Stuart Hen, Prostate Cancer, Palliative - Improved Survival, 10000
Stuart Hen, Prostate Cancer, Curative, 18000
Ben One, Brain Cancer, Curative, 85000
Stuart Hen, Bone Cancer, Palliative - Improved Survival, 16900
];
Above is a simplistic example of the type of data that I am working worth. What I would like to do is to rank according to Diagnosis, then rank according to Treatment Intent in another table based on the Doctor selected.
I would need to fields of output, one which has the data ranked within the table, i.e. prostate cancer, bone cancer etc for that specific doctor and then the second field to rank the diagnosis overall, i.e. for that specific doctor the cost for prostate cancer was ranked against all doctors cost for prostate cancer.
