Forum Discussion
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 you too in case you also still need an answer.
Regards,
Michelle
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
5 Replies
I'm afraid this couldn't be achieved, you need to add the column to the matrix and click ellipse, then select "Sort By".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mmm... that's strange. It definitely worked for me.
- 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.
