Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

Quarter table

Please help to create a table with the below criteria.   I have a Month Column in my tables. From this i need creatre another table with Quarter and sort it in Descending Order.   My Q1 is from D...
Need Help
dobregon's avatar
dobregon
Impactful Individual
6 years ago

As i see your quarters are not following the normal division in a year, in any case there are only 4 quarters so you can create a simply column calculated with IF

QuarterNum = IF( (Month = 12 || Month = 1 || Month = 2 ), 1, IF( (Month = 3 || Month = 4 || Month = 5 ), 2, IF( (Month = 6 || Month = 7 || Month = 8 ),3,4)))

 

  • unnijoy's avatar
    unnijoy
    Post Prodigy
    6 years ago

    Hi dobregon ,

     

    thanks for your quick reply.

     

    Can you please help me to get this in the format like QTR 1 - 2020. And when we use this in graph can we sort it like Latest quarter will come first.

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      unnijoy , Try Like

      Create a new column like, hope you have qtr no,

      Qtr Name = "QTR " & [Qtr No] & " - " & [Year]

      • unnijoy's avatar
        unnijoy
        Post Prodigy
        6 years ago

        Hi amitchandak ,

         

        I create a calculated column by combining Qtr and year. But still i am not able to sort it when i use that in x axis. Like latest QTR first.

         

        So the login what i use is I take the month number. And i use Switch function to get Quarter based on month number .

         

        For example if month number is 12 the switch will give me Q1. I i use to get the year using the Year function. 

        If month number is 12 then Q1 && Year (Date)+1. So i will get like below

        For December 2019= Q1 2020.

         

        Now my issue is with sorting. How to get the sorting done in this.