Month name sort in matrix table

[sameergupta60]

Hi,

how i can arrange the month sort by financial year,

below screen sort for your reference.

[timg · Accepted solution]

Hi Sameergupta60,

you can change the sorting of a column in the model tab of your report (see image 1). If you select the month column in this page, you will be able to select a different column to sort the months by (see image 2 & 3 for before/after). Is this perhaps what you were looking for?

Do keep in mind that the column mapping to the month column must be unique, so ideally you would sort it by a column like YYYYMM (202102 for example). You will not be able to sort it by a column which does not have a unique match. For example, sorting by the date column (DDMMYYYY) is not possible since there are multiple different dates within a single month.

image 1: model view (sort by option)

image 2: before change

image 3: after change

I hope this helps!

Best regards,

tim