Forum Discussion

LillyLegenda's avatar
LillyLegenda
Helper III
5 years ago
Solved

Matrix: Sorting by columns

Hi, I may have a simple question, but I just cannot get it to work.   I have a Matrix and I would like the user to be able to click on BB, DD or Inv to sort by the column. How is this possible?  ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    LillyLegenda 

     I think you cannot sort by column.

     
    Instead you can create New Column like below:


    BB = IF(Sheet1[OrderType] = "BB",Sheet1[Volume],0)
    DD = IF(Sheet1[OrderType] = "DD",Sheet1[Volume],0)
    INV = IF(Sheet1[OrderType] = "INV",Sheet1[Volume],0)


    Once done add these Columns to the "Values" and removed Order Type from "Columns". This will enable the sorting option as per your requirement.


    Please find screenshots below:

     

    Thanks,

    Sandeep

Anonymous's avatar
Anonymous
Not applicable
5 years ago

LillyLegenda 

 I think you cannot sort by column.

 
Instead you can create New Column like below:


BB = IF(Sheet1[OrderType] = "BB",Sheet1[Volume],0)
DD = IF(Sheet1[OrderType] = "DD",Sheet1[Volume],0)
INV = IF(Sheet1[OrderType] = "INV",Sheet1[Volume],0)


Once done add these Columns to the "Values" and removed Order Type from "Columns". This will enable the sorting option as per your requirement.


Please find screenshots below:

 

Thanks,

Sandeep

  • LillyLegenda's avatar
    LillyLegenda
    Helper III
    5 years ago

    Thank you very much Anonymous ! This is working fine. Maybe it is just me but I think it should be a normal feature in a matrix. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Other way to resolve this is using inforiver premium visual which sorts any invdividual column. However its paid if you want to publish the file for users to view it.

       

      Thanks,