Forum Discussion

dhirenp77's avatar
dhirenp77
Frequent Visitor
8 years ago
Solved

sort horizontal matrix column by Fiscal year Month

What is the best way to sort the fiscal year data by month?

 

I am using matrix visual.  first column is data source and i want to show values for each source in month column.  Month should be sorted by fiscal year starting in Nov. 2017-> Oct 2018.

I can have two rows year, month which will sort.  But i just want to show the Month names and the they should just be in fiscal year month sequence.  

 

Any feedback on how to accomplish will be very helpful.

 

thanks

  • Anonymous's avatar
    Anonymous
    8 years ago

    dhirenp77,

    You can create sequence number for your fiscal year month(Nov. 2017-> Oct 2018), the click the YearMonth column, and sort the column by the sequence number column. There is an example for your reference.



    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dhirenp77,

    You can create sequence number for your fiscal year month(Nov. 2017-> Oct 2018), the click the YearMonth column, and sort the column by the sequence number column. There is an example for your reference.



    Regards,
    Lydia

    • dhirenp77's avatar
      dhirenp77
      Frequent Visitor
      8 years ago

      Thanks.  That is exactly what i ended up doing.