Help with sorting

[fcecconi]

I am trying to sort a straight table by more than 1 column.  I have created 3 columns that will rank the data based on what columns the user selects.  This method works great for sorts on one column.  If the user selects a sort that would required 2 columns be sorted, the application will only sort by 1 column and ignore the other;

All of the ranking objects have an ascending sort enabled and the other objects don't have any sort associated with them.

any suggestions is greatly appreciated.

[jagan]

Hi,

If you attach the sample file then it would be easier to provide the solution.  I think if you define the order of the dimensions in the Sort tab correctly then it will sort according.  Order the Dimensions in Sort tab by

Chart Properties -> Sort -> Columns (Priority) -> Change the priority by using Promote and Demote buttons.

Hope this helps you.

Regards,

Jagan.

[fcecconi]

Unfortunately I can't post my application due to company policy.  I have already have the 3 rank columns in the proper sort priority.

[fcecconi]

Here is my sort priority screenshot

[fcecconi · Accepted solution]

Issue was due to the mode in the Ranking statement.  I switch from ,4 to ,1 and everything is sorting as expected.