Forum Discussion

kcngnkc's avatar
kcngnkc
Icon for Helper I rankHelper I
6 years ago

How to Sort Fiscal Calendar on Chart Axis

Hi All,   I have a data set that can be summarized by Fiscal Year, Fiscal Quarter, Fiscal Period, and Fiscal Week. In a line chart that I have created I was able to sort the Fiscal Weeks on the X-A...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

kcngnkc yes you have to have another sort column for the fiscal period, basically, you can have only a unique combination between the column you are sorting and column you are sorting on.

 

In this case:

 

ALL P1 rows will have one sort value and all P2 will have one sort value and so on..

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!