Forum Discussion
Solved
Matrix, sort column by date, index not working for 1 section
in this screen shot, i need 1st Q to show months as secondary layer, months should be sorted by my index which is table, only the 1st Quarter not sorted properly, rest of quarters are good. thi...
i just answered my own question, the month order is sorted automatically by calendar, because month display is from date hieracy-month in calendar table., solution is to display the year hieracy as well- although this will add more subtotal on columns, but that is another question.
i just answered my own question, the month order is sorted automatically by calendar, because month display is from date hieracy-month in calendar table., solution is to display the year hieracy as well- although this will add more subtotal on columns, but that is another question.