3 Replies Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    Monarch 10.5 Custom Sort Order

    lcwalker _

      Good morning.  I'm wondering if there is a way to create a custom sort order.  I need to sort a monthly summary report by fiscal year month, not by calendar month.

        • Monarch 10.5 Custom Sort Order
          Olly Bond

          Hello lcwalker,

           

          Yes, you can do this. For the month field that is the across key of the summary, you need to specify the values you want in the right order. To do this, open the summary properties, double click on the field, go to the matching tab and select the specific values option, then populate the list. Now go to the sorting tab and select "position in specified values list", and you should get the result you want.

           

          Hope this helps,

           

          Olly