Sorting by a Column that is not Included in a Cross Table


I am using Spotfire Version 7.6.1 for context. I have created a cross table that examines the accounting dollar amounts of different account entries over different periods of time. I would like to sort these accounts by their Base ID, but I do not want the Base ID to appear in the table. Since my "Functional Area" field is dynamic and dynamically changes with the Level I choose to show for it, custom sorting does not work since it changes after every time I switch the level. Therefore, I need to sort the functional areas by these Base IDs, but I do not want the user of these tables to see the Base IDs. Is there anyway I can sort by Base ID in ascending order for Functional Area without showing it?



(1) Answer