I have 400 plus Dimensions in my Straight Table. I am facing sorting issue in Straight Table, Sorting in the sense columns are not getting arranged in chart according to my selection.
Suppose i have dimension like Country, Address Line1, CSO Item Key, etc., If i select Country then CSO Item Key later Address Line1 Then i have to get result in Chart as i select but i am not getting respectively as my selections.
For this you need to query the selections from your selection-field quite similar to above mentioned but instead of getcurrentselections you would use getfieldselections. But this would only work for selections which are made one after another - if the user makes multiple selections by draging several values with mouse or pressing the ctrl-key to get the selection-order would fail.
As alternatively you could build fix selection-structures with a field or variable for each dimension but I doubt that will be a real option for you.
