Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Matrix Tool Expand / Collapse
Author
Message
Posted Friday, September 6, 2013 10:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 1:01 PM
Points: 215, Visits: 639
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: Yesterday @ 12:37 AM
Points: 3,127, Visits: 1,355
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
Post #1495438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse