Simple Technique for Custom Sort

micajblock

Let's say I want to sort in this order - High, Medium, Low. This is obviously not alphabeticaly. What I did in this example is create a column with values 1, 2, 3. Then used the Map tab to create a mapping where 1=High, 2- Medium, 3-Low. When one sorts on the coilumn (whether in BRD or Interactive Viewer) the column will be sorted on the values (1,2,3) but display the mappings (High, Medium, Low).