Forum Discussion
Sort Fiscal Quarter from Start Date
Hello all i have below start date column and based on this i want to convert to fiscal quarter and fiscal month is April. So based on custom calendar i have date,fiscalyearquarter column and i have joined start date and date. Now in a matrix i want to sort like this.
Always display 1st Quarter at 1st row. Please help me to sort.
| Start Date |
| 26-Jun-23 |
| 26-Jun-23 |
| 26-Jun-23 |
| 26-Jun-23 |
| 26-Jun-23 |
| 19-Jun-23 |
| 19-Jun-23 |
| 19-Jun-23 |
| 19-Jun-23 |
| 15-Jun-23 |
| 13-Jun-23 |
| 12-Jun-23 |
| 12-Jun-23 |
| 12-Jun-23 |
| 12-Jun-23 |
| 12-Jun-23 |
| 12-Jun-23 |
| 8-Jun-23 |
| 8-Jun-23 |
| 8-Jun-23 |
| 8-Jun-23 |
| 8-Jun-23 |
| 8-Jun-23 |
| 8-Jun-23 |
| 7-Jun-23 |
| 6-Jun-23 |
| 6-Jun-23 |
| 6-Jun-23 |
| 29-May-23 |
| 29-May-23 |
| 29-May-23 |
| 29-May-23 |
| 29-May-23 |
| 25-May-23 |
| 25-May-23 |
| 19-Jan-23 |
| 19-Jan-23 |
| 19-Jan-23 |
| 3-Jan-23 |
| 3-Jan-23 |
| 30-Dec-22 |
| 30-Dec-22 |
| 30-Dec-22 |
| 29-Dec-22 |
| 29-Dec-22 |
| 28-Dec-22 |
2 Replies
Hi harshagraj
You can refer to the following example.
Sample table
1.You can create a new table
2.Set the column1 to 'sorted by column 2'
3.Create the relationship between two tables
4.Then put the column1 of table2 to the matrix
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Anonymous this didnt help me and thanks a lot for the support. I need in matrix like this. Assuming April 2023, May 2023, June 2023 is current quarter and Jan 2023, Feb 2023, March 2023 and so on is previus quarter then 2023Q1,2022Q4,2022Q3 and so on.
