Forum Discussion

heygowtam's avatar
heygowtam
Icon for Helper II rankHelper II
3 years ago

Horizontal Month name sort in Matrix

I Need to arrange the Month name in Order Because it is in the Financial Year Date Table July and August are not in Order in MATRIX Table.   is there any way to sort this out,
Need Help
  • Thennarasu_R's avatar
    Thennarasu_R
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    You Need To created one Calculatd column

    Column=format(Datecolumn,"yyyymm")

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      3 years ago

      Hi heygowtam ,

       

      The same solution should also work on other uses cases. I've had several data models that used Fiscal Year and the custom column sort worked perfectly. I would have something like below where YYYYMM is used as custom sort column.

       

      • heygowtam's avatar
        heygowtam
        Icon for Helper II rankHelper II
        3 years ago

        danextian I think it may work on all other graphs, I have used them as well. 

        But, with the MatriX Visual I am not sure it works