Forum Discussion
Sorting by Particular Column in a hierarchy
Hi, I have this Actual Revenue & Expenses Matrix table. I want the Hierarchy to be in this Order (Image !), but I want the GL/Source Summary Account Title fiels to be sorted in particular Order. ...
is your sort by column of numerical type? it should be numerical
v-lili6-msft
Community Support
Community SupportHI, Anonymous
Add an index column for GL/Source Summary Account Title in Edit Queries.
For example:
Then set sort by column
Result:
Best Regards,
Lin
Hi v-lili6-msft ,
Thank you for your reply.
I did the same way...but it still doesn't work.
Don't know what I am missing ....
bogomdaResolver I
seems like you did everything right, but you might probably forgot to do following:
on the visual itself, => choose more options => choose Sorty By => choose GL/Source Summary Account Title.
Below is the example. Once you do it, it should resort it in your desired order.
Try sort the column in the database itself, Did you try that ?