September 6, 2013 at 10:21 am
When I display the Date field in a table it comes in the same order in SQL (SMS).
But when I add it as a row (pivot style) in a matrix. It messes up the order.
Any suggestions?
September 17, 2013 at 4:36 am
When using the matrix (pivot) style the row and column groups automatically set the group by and the sorting by properties for the group.
To retain the sort order from the input dataset,
- open the properties of the row/column group,
- select the sorting tab
- remove all the sort items.
I do this regularly with SSAS datasets where the months have a key value of Year/Month but show the month / year as "April 2010". The automatic sorting reverts to alphabetic sort by month name.
Fitz
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply