Forum Discussion

wenners68's avatar
wenners68
Icon for Helper II rankHelper II
8 years ago
Solved

Order column chart by month over multiple years

I'm trying to order the columns by month over a financial year that starts in May and finishes in April. Most examples I have come across only deals with January to December scenarios. Any ideas ho...
Need Help
Show and Tell
Tips and Tricks
  • RolandsP's avatar
    RolandsP
    8 years ago

    Formula should be:

     

    Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)

  • wenners68's avatar
    wenners68
    8 years ago

    Thanks, that does it :-)

RolandsP's avatar
RolandsP
Icon for Resolver IV rankResolver IV
8 years ago

You have field Financial Month Number. Sort Month column by that field.

wenners68's avatar
wenners68
Icon for Helper II rankHelper II
8 years ago

 

Nope

  • RolandsP's avatar
    RolandsP
    Icon for Resolver IV rankResolver IV
    8 years ago

    Then you need to check value in this field. Based on the chart you sent for Jan you have number 5, although it should be 9.

    • wenners68's avatar
      wenners68
      Icon for Helper II rankHelper II
      8 years ago

      Yes, you're correct. I used the following calculation to get the financial month:

      Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+4,DateKey[Month number]-4)

       

      Problem being that my financial starts in May (month #5) and finishes in April (month #4), so the calc above won't cope with that scenario.

      • RolandsP's avatar
        RolandsP
        Icon for Resolver IV rankResolver IV
        8 years ago

        Formula should be:

         

        Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)