Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

 

 

 

 

 

 

 

 

 

 

 

 

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

 

 

Need Help
  • bogomda's avatar
    bogomda
    7 years ago

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

10 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • bogomda's avatar
        bogomda
        Resolver I
        7 years ago

        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.