Forum Discussion
matrix month sort incorrect
I have figured it out, it's quite simple I was confusing the functionality between sorting a column and sorting a column by ANOTHER column. I simply had to click on my accounting month name column, then click sort by column KEY_AccountingPeriod and sorts correctly. Clicking sort ascdending/descending on any column was not necessary
If you add KEY_AccountingPeriod (YYYYMM) field (the one converted to integer) to the table and then select sort ascending using the field what are the results you are getting?
Hi thanks for your reply, just to be specific you mean add KEY_AccountingPeriod to the matrix? select sort ascending using which field KEY_AccountingPeriod or AccountingMonthName?
i sort by accounting period, correct although i notice my key_accountingdate is now incorrect in some areaskey_accounting period is correct in matrixaccounting month name still incorrect on it's own
I have figured it out, it's quite simple I was confusing the functionality between sorting a column and sorting a column by ANOTHER column. I simply had to click on my accounting month name column, then click sort by column KEY_AccountingPeriod and sorts correctly. Clicking sort ascdending/descending on any column was not necessary