Forum Discussion

aslan's avatar
aslan
Icon for Helper I rankHelper I
9 years ago
Solved

Matrix - Sorting

Hi ,   In below image matrix grouping by rows and then sort by value. But it is not useful for my client.  8 value should be after the 16 but it is before in current logic. Can you please help me t...
Need Help
  • Sean's avatar
    Sean
    9 years ago
    aslan wrote:

    Correct order should be 17 - 16 - 16 - 8

     

    If you want this order you need to swap the order in the Rows Field of you Matrix.

    You currenty have cat/mod - you need mod/cat - but then I don't get how 6+16=16 on the 3rd line in your picture below the 8?

     

     

    And if you want to see what sorting at each level in Excel is - here's a picture... (and this is obviously a very simple example)

     

     

    Good Luck to you! :smileywink:

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago
aslan wrote:

Correct order should be 17 - 16 - 16 - 8

 

If you want this order you need to swap the order in the Rows Field of you Matrix.

You currenty have cat/mod - you need mod/cat - but then I don't get how 6+16=16 on the 3rd line in your picture below the 8?

 

 

And if you want to see what sorting at each level in Excel is - here's a picture... (and this is obviously a very simple example)

 

 

Good Luck to you! :smileywink: