Forum Discussion
harshagraj
Post Partisan
Post PartisanSort 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 j...
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.
harshagrajPost Partisan
Post PartisanHI 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.