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

Options
Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First Anniversary
in Platform

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
    March Badge of the Month February Badge of the Month Community Captain April Badge of the Month
    edited March 2020
    Options

    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

Categories