Quarter table

Question

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 December - February. Like this i have to create the Quarter.

Please help to create a table like this.

dobregon · Answer

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 · Answer

Hi&nbsp;dobregon&nbsp;,&nbsp;thanks for your quick reply.&nbsp;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 · Answer

unnijoy , Try Like
Create a new column like, hope you have qtr no,
Qtr Name = "QTR " &amp; [Qtr No] &amp; " - " &amp; [Year]

unnijoy · Answer

Hi&nbsp;amitchandak&nbsp;,&nbsp;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.&nbsp;So the login what i use is I take the month number. And i use Switch function to get Quarter based on month number .&nbsp;For example if month number is 12 the switch will give me Q1. I i use to get the year using the Year function.&nbsp;If month number is 12 then Q1 &amp;&amp; Year (Date)+1. So i will get like belowFor December 2019= Q1 2020.&nbsp;Now my issue is with sorting. How to get the sorting done in this.

dobregon · Answer

unnijoy&nbsp;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

Forum Discussion

Quarter table

8 Replies

Related content

Quarter over Quarter calculation - Display Quarters missing

Calculating Quarter over Quarter Change

Quarter calculation upto selected month

Ordering Data by Quarters

Last 3 quarter