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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 15580
  • Last Modified:

Reporting Services 2005: Adding Total footer to bottom of matrix

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
RepriseMIS
Asked:
RepriseMIS
  • 2
1 Solution
 
simon_kirkCommented:
Right click the cell you wish to total and select Sub Total
0
 
RepriseMISAuthor Commented:
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
 
YurichCommented:
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
 
simon_kirkCommented:
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now