Forum Discussion

lekkerbek's avatar
lekkerbek
Icon for Helper IV rankHelper IV
9 years ago

Date sorting in Matrix

Hi,   I have created a matrix and I put the date in the columns field.   It gives me the information I want, but I want to start with the most recent year and previous years should be more to the...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi lekkerbek,

As the Greg_Deckler posted, please click the triangle button highlighted in red line at the column hearder, order by data ASC or DESC. 

 

 

If this doesn't resovle your problem, please post detail information or screenshot.

 

Best Regards,
Angelia

  • lekkerbek's avatar
    lekkerbek
    Icon for Helper IV rankHelper IV
    9 years ago

    Hi,

     

    I believe you are referring to a table? My problem is with the matrix.

     

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi lekkerbek,

       

      It's a matrix, I don't add the legend level, so it likes table. Based on your description, you can choose data rather than hierarchy.

       

       

      Best Regards,

      Angelia

      • lekkerbek's avatar
        lekkerbek
        Icon for Helper IV rankHelper IV
        9 years ago

        Ah I see what you mean, but my date is the columns section (and needs to be there for the correct presentation).