Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

column order matrix

Hello everyone, 

I have created this matrix, I have as column one filed ( with values BtoB,Retail)

I would like to dislay first the Retail part and after the BtoB part. 

Where can I change this ? It seems to be automatic.

 

Thanks for your help 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    add a new column in your table
    Sort = IF( mytabl[filed] = "Retail",1,2)
    then sort the mytabl[filed] column by Sort column

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    add a new column in your table
    Sort = IF( mytabl[filed] = "Retail",1,2)
    then sort the mytabl[filed] column by Sort column

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I put my new column in the dimension tab,  then I add to the matrix in the column the new field , then I click on the 3 button ... on the right corner of the matrix and do sort by ' my new field' ; this is not working.  Am I missing something  ? Do you have a video to help me ?