Forum Discussion

mussaenda's avatar
mussaenda
Community Champion
1 year ago

Matrix sort rows by values

I knooooow, I know there is this limit that we cannot sort the values if we have columns in Matrix Table. Buuuut I am desperate to know if there are any workaround to sort the values according to t...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Super User
1 year ago

Change the Row total computation to include only September data.  Sort by the Row Total.

mussaenda's avatar
mussaenda
Community Champion
1 year ago

Hi lbendlin ,

 

Thanks for the suggestion. But that's the thing, they don't want to limit it to September only. It should be according to their choice.

 

If they want to sort the Deposits in Aug, they should be able to sort it. If they want to sor the NMI in July, they should be able to sort it.

 

One workaround I did before was manually adding each column by month i.e. Deposit - September, Withdrawal - September and so on.. But it takes effort and time to always add new columns if there will be new month.

  • bgatzemeyer's avatar
    bgatzemeyer
    Frequent Visitor
    1 year ago

    I have this exact same use case I need solved.  Subscribing to the thread in hopes of an answer!

    Thanks mussaenda  you saved me from posting my own question 🙂