Here is the file. Thanks for your help!
My end goal is to sort first by campus numerically, then secondly by ins_full_name desc.
My second chart concats the two together which only shows the records I want, but then I have a hard time figuring out the sort, Plus I don't want to duplicate the campus number on every row; I'd prefer to have it there once.
Please check if this representation helps by writing small script and using dimension accordingly, attaching chart qvw as well.
Load *, [IU Campus] & '-' & ins_full_name as [IU_INS]
test3.qvw 157.0 K
Almost, I have done that as well but I have a couple problems with that way:
1. I prefer to not have it repeat the campus number for every row
2. more importantly I need to be able to sort it first by campus number, then by name's value decending with the the records with the highest numbers on top by campus number.