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

Previous Member

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

Helmut Heimann

Hi HARISHA DK,

 

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

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