Sorting of a Straight Table

[BogdanT18]

Hello,

I am trying to sort a table descending by a column and the result I get VS the results I get when I click on the column name in the table to sort it descending (not in edit mode) are different. The result I get when I click on the column name is the expected result. How can I achieve this?

Thank you!

Bogdan

[Cascader]

send screenshot of sort tab please

[Rams-]

Hi,

You have Sorting option in Properties

You can set By default Sorting option by dragging the up-down field names.

Off the Auto Sorting option.

Then you can sort according to your requirement.

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[BogdanT18]

Hello @Cascader , @Rams- ,

I will attach some sample data:

pic1: this is sorting with no limitation

pic2:if I only set the limitation to fixed number, the sorting changes

What I expect is to have the same sorting I have in pic1 in the limitation scenario so I can have the first x number of recordings according to the variable that is editable in the front end. 

Do you have any idea of why it changes? And how can I make it not to? 

Thank you!

[Aditya_Chitale]

Try shifting the measure on top most position in sorting tab on which you want to primarily sort your table and then  apply fixed value on the least granular field of your table.

Regards,

Aditya

[BogdanT18]

Hello,

The problem was that when you select limitation to fixed value, it takes the first measure in your table. It says calculated on measure: -MeasureName-. So I needed to compromise and move my measure all the way to the left so it will be the first measure in my table so that the limitation would be calculated on it....initially was all the way to the right because I wanted to "hide" it, as the sorting is it's only purpose.

Thank you all for your inputs! 😄