How to display data in descending order at all levels of axes in a data view

When i'm  trying to display the values in the descending order, in filter i put referenced  cube and i got sorted order,

  but only in the leaf axes.On collapsing the data view its not showing the sorted order at the higher level axes

is there any way to achieve ..!!

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited March 2020

    Hi HARISHA DK,

     

    generally, BOARD sorts entities by the sorting oder provided in the entities tab of the database

    image

    You can find more information on this topic in our help: Creating an entity

     

    So the best way to achieve your aim would be to mark one of your entities as "sort by none" and load the data in the order you'd like to show on the dataview, the other entity can be sorted by the cube you've mentioned.

    Another option could be to enhance the "sorting cube" containing both father and child of your entity (sorted according to your needs). I've not yet tried that but it might work.

     

    Kind Regards,

    Helmut