Post reply

Matrix | Column Group | Sorting > Expression to set order by but set one specific column data as last column displayed

  • November 10, 2010 at 1:52 am

    #241071

    Example:

    I have this column data as a results and they will sorted like this when i set up sort expression:

    A | B | C | M | X | Y | Z

    But i want "M" column to be the last column, so i expect the result like this:

    A | B | C | X | Y | Z | M

    Is it possible?

    Thanks for reading. 😛

  • November 10, 2010 at 2:55 pm

    #1249188

    You might need to add a column to your dataset that allows you to create a manual sort so the the sort value for M is greater than the sort value for Z. Perhaps if you only want M to sort last, a computed value or column with a formula that says something like IIF(fieldvalue = "M","[",fieldvalue) and sort on that. The "[" should sort higher than Z.

  • November 10, 2010 at 9:40 pm

    #1249242

    Thanks for replying. It is good right now. 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply