Groups | Blog | Home
all groups > sql server reporting services > august 2004 >

sql server reporting services : Subtotals



Laura
8/31/2004 4:59:06 PM
Hi,

I want to know if you can edit the Subtotal function for a matrix? I have
two columns namely: TY, LY, % Diff (TY - LY). When I do a "Subtotal" it adds
even the % Diff column. I want it to do the equation TY-LY. Is there a way to
do that?

Chris Hays [MSFT]
8/31/2004 5:28:47 PM
You should be able to use these expressions in your data cells:

=Sum(Fields!TY.Value)
=Sum(Fields!LY.Value)
=(Sum(Fields!TY.Value)-Sum(Fields!LY.Value))/Sum(Fields!TY.Value)

--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
[quoted text, click to view]

AddThis Social Bookmark Button