Hello,
I have a matrix with one row group and one column group.
The column will not flipping sort by the tinyint I am using. I have put the sorting everywhere I can think of and cannot find a solution on the web. In the query are quarters, Qtr1, Qtr2, 1st Q, 2nd Q ... as well as sort order column (1,2,3) .. which tells what the order of the quarters are; that column is a tinyint. The matrix is sorting on the quarters no matter what I do, the sort is always 1st, 2nd, Q1, Q2.
???????
TIA
Jeff