Forum Discussion

EmmaLynch's avatar
EmmaLynch
Frequent Visitor
6 years ago
Solved

RE ORDERING COLUMNS IN MATRIX VISUALIZATION

Hi,

I have created the below basic matrix - problem is I need to reorder the columns to be AA, A, B, C & D as AA is better than A and therefore needs to show first.  The matrix is sorting is alphabetically, so putting AA behind A, which I dont want.

 

Could anyhelp be in layman terms please as I am not very technical.

 

Thanks in advance 🙂

 

  • Sujit_Thakur's avatar
    Sujit_Thakur
    6 years ago

    Dear EmmaLynch ,
    This is what i used to suffer in,

    Simply change order in which they are put in the field.
    Or 
    The best practise is
    make a new table by using enter data option from main tool ribbon on the top of screen.
    Make such table

    Entity         Direction

    AA               1

    A                  2

    B                  3

    C                 4

    D                   5

    Then realted Entitty with the column from the main data table.

    Then you can see a sort option ,
    here select sort by Direction.(This is column of new table you created ).

    It will do the help always 

    Please do not hesitate to give kudos 
    If this helped select this post as solution

    Regards 
    Sujit

3 Replies

  • Sujit_Thakur's avatar
    Sujit_Thakur
    Solution Sage
    6 years ago

    Dear EmmaLynch ,
    This is what i used to suffer in,

    Simply change order in which they are put in the field.
    Or 
    The best practise is
    make a new table by using enter data option from main tool ribbon on the top of screen.
    Make such table

    Entity         Direction

    AA               1

    A                  2

    B                  3

    C                 4

    D                   5

    Then realted Entitty with the column from the main data table.

    Then you can see a sort option ,
    here select sort by Direction.(This is column of new table you created ).

    It will do the help always 

    Please do not hesitate to give kudos 
    If this helped select this post as solution

    Regards 
    Sujit

  • mhossain's avatar
    mhossain
    Solution Sage
    6 years ago

    EmmaLynch 

     

    1). Create a table using GroupBY  Contract Class and second column as count, and then create a rankx column to rank your 'Contract Class'

    2). Drag contract class from above table to matrix visual, and use SORT BY column as per rankx column.

     

    Let me know if above makes sense. will you be using any slicer? Above rankx will be done at total count at Contract Class.