Sorting a column two different ways

[SanderVeeken]

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 to display them by schoolyear order (starting in August and ending with July).

I have a "schoolmonth" column and I can easily set "month name" to sort by schoolmonth. However, then I run into trouble for the "fiscal year" graph where I want the "normal" sort order by regular month number. Is there some provision for this, or a clever way I'm missing? The only workaround I can think of is to duplicate the month name column and call it fiscal month name or something, and sort that one by month number.

[MFelix]

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.