Forum Discussion

michellepace's avatar
michellepace
Icon for Resolver III rankResolver III
7 years ago
Solved

Sort Matrix by field which is not in the Matrix (Income Statement)

Hi there, I'd like to sort my matrix rows by a (non-calculated) field, namely FinCode. But I don't want to display this field in my matrix.  Is there a way to do this?   Anonymousincluding yo...
Need Help
  • michellepace's avatar
    michellepace
    7 years ago

    Hi freder1ck - yes that's for sure the answer (and elegantly put I must say!). As a newbie though (which I am) I still had to figure it out step by step. 

     

    Here is a quick video showing the solution: https://youtu.be/n7VYW-vfCrY

     

     

michellepace's avatar
michellepace
Icon for Resolver III rankResolver III
7 years ago

Mmm... that's strange. It definitely worked for me.

 

freder1ck's avatar
freder1ck
Icon for Kudo Kingpin rankKudo Kingpin
7 years ago
Hi Michelle,
Have you tried setting Fin Descr to sort by Fin Code? In data view, go to the modeling tab. Click Fin Discr column and then the sort by button. Sort it by Fin Code. Then you can sort by description and it will sort as you prefer.