matrix: Hide column and sort by each column
Can hide the column in the Matrix and sort the data by each column
Gordon Hayward commented
In showing GL info in Matrix, need to group by Department and Account. But need to order Accounts by hidden sort as they shouldn't be sorted by Acct # nor Acct Name - need a hidden sort order as secondary to Department. Don't want to show or have totals by that hidden sort order.
I agree. Need the ability to have the column in the Matrix for sort purposes but need the ability to hide it from display.