Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Matrix Report

Posted on 2011-10-05
Medium Priority
Last Modified: 2012-05-12
I am trying to create a matrix report.  I want to show the time taken to close a issue on different products and number of issues closed on those products in between a time frame. So i used years as rows and product as columns in data i used issue count and time. Now i want to see the total issue count , so i added subtotal on years and i am getting total number of issues closed per product. Now i am also getting total of duration as well.  And the total of duration that i am getting is wrong.  So how can i get the correct total of duration. or is there a way that i can only do sum of issue count?
Question by:Svlss
1 Comment
LVL 40

Accepted Solution

lcohan earned 2000 total points
ID: 36919461
In my opinion you can't do it in the matrix as described because they will be grouped(summed) by "row" (year in your case)  implicitely.
You should have the total (sum) of the counts per product not by year per product

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question