Matrix Report

Posted on 2011-10-05
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 39

    Accepted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now