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
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.

    • dobregon's avatar
      dobregon
      Impactful Individual
      6 years ago

      unnijoy now that you have the column with the format of QTR, number and year that you want. then you have in the X axis.

      if you click in the visual you will see 3 points on the top right, click on this, select sort ascending by and here select your X axis and then you will have your x axis sorted like Q1 2020, Q2 2020, Q3 2020, etc

      • unnijoy's avatar
        unnijoy
        Post Prodigy
        6 years ago

        its no giving me in the correct sort order.