Sorting by Particular Column in a hierarchy

[Anonymous]

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.

I tried creating a conditional column with GL/Source Account Summary ID & sorted the GL/Source title column by the ID column.

But it doesn't work.

I will really appreciate any help on this.

Thanks!!

[v-lili6-msft]

HI, @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

[Anonymous]

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 ....

[Anonymous]

Try sort the column in the database itself, Did you try that ?

[bogomda]

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.

[Anonymous]

I did that too...:(

Thank you @bogomda !!

[parry2k]

@Anonymous can you confirm and make sure you sorted your ("GL/Source SUmmary Account Title" by "Account SUmmary Id" in model tab using "sort by column"

Can you send the screen shot if you did it?

[Anonymous]

Hi @parry2k ...Thank you!!

Its solved..I had to set the Gl/Source ID as whole number.

[parry2k]

@Anonymous  that make sense. glad to hear. cheers

[bogomda · Accepted solution]

is your sort by column of numerical type? it should be numerical

[Anonymous]

OMG....You are Awesome!! @bogomda 

It worked!! 🙂 🙂

Thank you so much!!!