Solved

Reporting Services 2005: Adding Total footer to bottom of matrix

Posted on 2006-07-21
4
15,533 Views
Last Modified: 2011-10-03
i have a matrix that has a series of row groups, and then a few column groups with the data that i am pivoting. what i am trying to do is get the Sum of the data in the row groups and display it across the bottom of the matrix. the matrix control doesnt let you add a footer like the table control does. is there a way to do this or am i out of luck?
0
Comment
Question by:RepriseMIS
  • 2
4 Comments
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17162757
Right click the cell you wish to total and select Sub Total
0
 

Author Comment

by:RepriseMIS
ID: 17162897
I've tried that, and it does the sub total for each row, not for the total of the entire matrix. What im looking for is a bottom line grand total for all columns in the matrix.
0
 
LVL 21

Expert Comment

by:Yurich
ID: 17164084
as a workaround, you can sum up all other counts, like

=Count( Fields!val1.Value ) + Count( Fields!val2.Value ) + ... + Count( Fields!valN.Value )

regs,
yurich
0
 
LVL 14

Accepted Solution

by:
simon_kirk earned 500 total points
ID: 17166720
If you add a subtotal for the Column AND Row, then the Column totals should be totaled as a row grand total.  e.g.

                  ColumnType1        ColumnType2    TOTAL
RowType1              100                      320          420
RowType2              250                      400          650
TOTAL                   350                      720         1070 <---- Grand Total
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

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

21 Experts available now in Live!

Get 1:1 Help Now