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

SSRS Matrix Difference Expand / Collapse
Author
Message
Posted Monday, December 30, 2013 10:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 10:55 AM
Points: 114, Visits: 146

I have 2 matrices a below that has a row group on Category and column group on product and Time(Year, Month and Quarter)

I want to create a matrix with the variance of 2 matrices . See attachment for more details



  Post Attachments 
Question.docx (5 views, 54.32 KB)
Post #1526554
Posted Friday, January 3, 2014 6:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 1:33 AM
Points: 102, Visits: 144
Try getting the variance at the query level.
Post #1527495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse