Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Matrix Tool Expand / Collapse
Posted Friday, September 6, 2013 10:21 AM


Group: General Forum Members
Last Login: Monday, December 5, 2016 9:48 AM
Points: 406, Visits: 1,219
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?
Post #1492331
Posted Tuesday, September 17, 2013 4:36 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, November 18, 2016 1:24 AM
Points: 3,662, Visits: 1,510
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.

Post #1495438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse