Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorting visual by column with letter prefix

Hello, i am trying to sort the following (Drill-Down) visual by the attribute UnterkapitelID of the following table   Since the ID contains letters, 10, 11, 12 etc. they sorted before 2...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , If you have create a column(B) from Column (A), then you can not sort Column A on B.

 

Do Like

A1 = [A]

B = sort using A

Then Sort A1 on B and use A1 in visual

 

Also A and B should have same granularity. Means 1-1 Mapping values 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
    Do Like

    A1 = [A]

    B = sort using A

    Then Sort A1 on B and use A1 in visual

     

     What exactly do you mean by do A1 = [A] ?