Forum Discussion

MarkPendragon's avatar
MarkPendragon
Regular Visitor
8 years ago

How do I sort using my original data order ( ie NOT Alphanumeric but by a sql column order )

Hi, I have a list of accounting lines that I wish to import into a matrix and to retain the order that they appear in the table. I have had to create a subset of the full list of account report names...
MattAllington's avatar
MattAllington
Community Champion
8 years ago

There is a sort by column button in the Modeling tab (I think that is where it is). The cardinality of the column you want to change sort order for (away form alpha) needs to be the same as the sort by column. 

MarkPendragon's avatar
MarkPendragon
Regular Visitor
8 years ago

Hi,

 

The "sort by column" in the modelling tab is greyed out. So not available for me.

 

Thanks

Mark

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi MarkPendragon,

    When the visual is selected but no column is selected in the Fields pane, the Sort by Column button is inactive (grayed out). Make sure, you have selected the column which needs to be sorted like month name.

    Best Regards,
    Angelia

    • MarkPendragon's avatar
      MarkPendragon
      Regular Visitor
      8 years ago

      Hi,  I am sorry but maybe I am missing something simple here. I have tried clicking all combinations of row/column and get these various scenarios highlighted, but none of them activate the 'sort by column' option.  It must be something very simple that I am missing but I cannot see it.  

       

       

       

       

       

       

       

      Should I have 'drill on... columns' selected perhaps ?

       

      Thanks in advance.

      Mark

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi MarkPendragon,

        You should select the column name(highlighted in red line) in the fields area instead of visual as follows.



        Best Regards,
        Angelia