Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hiding A Sorting Row in A Matrix

Please help me with my Matrix.   I have a matrix I created so that users can drill down to lower levels to see what values live underneath them.   The problem I am having is that I want to sort b...
Need Help
michellepace's avatar
michellepace
Resolver III
7 years ago

Hi Anonymous , its actually quite a simple process to do what you need. It's just difficult to describe in words. I've made a little video for you. The trick is sorting the AccountSubGroup field by the LEVEL field (make sure your Level field is already sorted in ascending order). Here you go:

 

How to sort a matrix by a "hidden" field: https://youtu.be/n7VYW-vfCrY

dom99's avatar
dom99
Advocate V
6 years ago

Thanks for the youtube video. Without it I wouldnt have got this working, I didnt realise you had to order the specific column by the column you want to sort by (I can see why describing it is difficult). 

 

Anyway thanks :)