Forum Discussion

barlevitzky's avatar
barlevitzky
Helper 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. 

     

wwhittenton's avatar
wwhittenton
Helper II
8 years ago

barlevitzky Are the columns being created from a single data source? i.e. 407, 537, 552, etc. are all loaded into the matrix through one data source?

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    8 years ago

    wwhittenton

     

    I got his point:

    • He is using Sales Qty in Columns field in the actual Matrix and would like to see Qty's in a Desc order not sure if it's actually possible.

     

    • barlevitzky's avatar
      barlevitzky
      Helper I
      8 years ago

      Abduvali, yes. these numbers are coming from "ID" column. 

      we can relate that to store id and revenue per store. So i want to see first the store with the highest revenue.