Forum Discussion

SanderVeeken's avatar
SanderVeeken
Icon for Helper III rankHelper III
3 years ago

Sorting a column two different ways

I have a case where I have to sort the x-axis of a stacked column chart two different ways; in one case (fiscal year) I want to display the month names sorted by month number, in another case, I want...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi SanderVeeken ,

 

You can't sort the same column by two different columns, my experience with calendar table that have a fiscal year and a calendar year I always have the calendar columns (year, months, quarter) and the fiscal ones, in this case believe that you need to have this duplication of the month name and of the fiscal month name.