fix (hold) the row order, in a pivot table

[becki_kain]

I have this load script so that my vehicles are displayed in a set order and this works fine, until someone click on a Segment, then the segment which was clicked on goes to the bottom of the table.  if I remove this part of the load script, the rows do not change, no matter what is clicked on, but the order of rows is based on the raw input.  how do I hold or fix the order of the rows to comply with the load script?

Segments:
LOAD * INLINE
[ Segment, SortOrder
Small B Car, 1
Small C Car, 2
Medium Car, 3
Large Car, 4
Sports, 5

];

the sort for the dimension "Segment" is set only to Expression->ascending->=SortOrder

thank you

Becki Kain

[krishnacbe]

Hi,

Check in Sort tab whether State Check box is enabled or not. If it is enabled, disable it.

[becki_kain]

nope, just the expression ascending on sort order for the dimension "Segment"

[lorenzoconforti]

Hi, just to understand. Your Pivot table contains the dimension Segment which you sort using the SortOrder field. You mention that users click on segment and this causes the selected Segment to go to the bottom of the table. This implies that there is some sort of set analysis that still allows you to see the other segments. Am I correct?

What could be happening is that, when you select a segment, you are filtering your data set (the $ state) so your are filtering out the sort order for the other segment. The application might not have them anymore to be able to sort properly. Can you please share the expression in the pivot table?

[pradosh_thakur]

can you share a sample?  with your intended output on image or excel

regards

Pradosh

[becki_kain]

attached. the only difference btn these projects is the one with load in the name has the load script with sort order, the other one does not.  in the one without the sort order in the load script , the order of the segments do not change and is based on how the input came in, with the soft order put in, the order of the segments changes based on user pick.  thanks

[becki_kain]

see above, thanks

[lorenzoconforti · Accepted solution]

See below

[krishnacbe]

In both your dimension Sort Property you have enabled State Sorting

[becki_kain]

that is it sir, thank you.  where are all these nuances documented???  thank you again!