Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding index in a calculated table for sorting purposes

Hi everyone!   I've used the solution on adding total to a clustered chart from this thread and it worked perfectly. The only thing is that the order of columns is not OK now (see the picture below...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    One way is to add the calculated column to tooltips filed of the visual as tex628 mentioned and click "..." on the visual then sort by calculated column.

    Another way is create a custom column in Query Editor and sort the column1 by the custom column (no need to add custom column to tooltips field).

    But as you said your table is a calculated table so the second way is not suitable for your current scenario but you might use it someday😁

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.