Howto do totaling in column wide in matrix table

Hi
Can some one help me please ? I am using matrix table and i need to do total column wide say example
priority 1 priority 2 P 3
$ 100 $ 500 $ 200
$ 1000 $ 1000 $ 1000
-
TOTAL HOW DO I GET THIS TOTAL FOR each column
--

Thanks in advance

[272 byte] By [Nirad] at [2008-2-15]

«« Returning results to MSMQ from SSIS Package
»» 2005 Cursor Looping Issue

# 1

I assume there is a matrix row grouping. Select the matrix row grouping header in layout mode, right click on it, and the popup menu should contain an entry for "Subtotal". Select it and you should get your subtotals. Note: by default the subtotal cells will use the same formula as regular matrix cells to calculate the subtotal. Make sure you are using an aggregate function like =Sum(...) in the matrix cells.

--Robert

RobertBrucknerMSFT at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

Robert
Thanks but that is doing subtotaling but I need totaling
P1 P2 P3
--
Site $120 $110 $130
Electrical $100 $180 $110

Total I need this total not subtotal
if you do subtotal than what it does is suppose there is 2 site item and 4 electrical item so it does that subtotaling now thegrand total. I need the grand total column wide.Hope you understand my situation.

Nirad at 2007-9-8 >

# 3

Grand totals work the same as subtotals are the same as a but at the most outer level of grouping.

BrianWelcker at 2007-9-8 >

# 4

Can I step in an then ask how to do the same on a table? I can't get this to work on my table! Tried using SUM(samefield in my column) and it's overinflated in my footer.

dba123 at 2007-9-8 >

# 5

Please make sure that you are using an aggregate function in the group headers/footers. Then the table footer should make sense compared to the group level aggregations.

-- Robert

RobertBrucknerMSFT at 2007-9-8 >

# 6

Thank you Rob!

dba123 at 2007-9-8 >

# 7

Hi Rob,

How do i Calculate %Change Between Priority1, Priority2 And Priority3 Columns

Thank you,

Regards,

Balwant Patel

BalwantPatel at 2007-9-8 >