Forum Discussion

barlevitzky's avatar
barlevitzky
Icon for Helper I rankHelper I
8 years ago
Solved

Sort by value

Hi all, I am trying to sort these table columns by values (column revenue), so the higher total value will be the first from the left and so on.  I clicked on the sort by column but nothing happene...
Need Help
  • barlevitzky's avatar
    barlevitzky
    8 years ago

    Hi All,

    I found a workaround solution. 

    After I changed between Rows and Columns parameter (ID will be Rows instead of Date) and apply column subtotal, I was able to sort by Sum of revenue values.

     

    So the final result wasn't exactly like I wanted to but we will have to adjust it. 

     

Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Hi barlevitzky,

 

Use sorting on the column in the actual table:

 

 

Regards

Abduvali

 

 

  • barlevitzky's avatar
    barlevitzky
    Icon for Helper I rankHelper I
    8 years ago

    Hi, Abduvali

    I am using Matrix and not a Table.

    Sorry that I wasn't clear about it. 

    • Abduvali's avatar
      Abduvali
      Icon for Skilled Sharer rankSkilled Sharer
      8 years ago

      My screenshot is on Matrix as well.

      • barlevitzky's avatar
        barlevitzky
        Icon for Helper I rankHelper I
        8 years ago

        Abduvali

         

        1. The total in your sales column is higher, so sales column should be the left column. 

        2. I don't know what is the difference between our matrixes, but when I point with the mouse on the column title I don't have sort option. only on the date column i have it.