I have weekly Cost and Quantity values in columns that are grouped by month. I need to get the Montly subtotal for the Cost column but not for the Quanity column (since this is not additive). When I put the subtotal into the matrix I get a subtotal for Cost and Quantity. How can I hide the Quantity subtotal or prevent this from occurring? TIADean

Hello,If you don't want to display the quantity data in the sub total row then add this expression for displaying of quantity data.Expression:=IIF(Inscope("GroupName"),Sum(Fields!Quantity.Value),"")Hop helpful...Thanks,PavanPavan

Where do I add itMr Shaw

Hello,Ad this in the cell where you want to display the quantity field.Hope helpful..Pavan http://www.ggktech.com

It is not possible to do this since the cell which I would add it to is part of the defualt subtotal. Therefore I am not able to access it in desgin view.Mr Shaw

Here's what I used in my report to hide the subtotal column based on a condition: In the visibility property of the textbox that displays the main data of the matrix, I put =iif(countdistinct(fields!SOMEFIELD.Value) > 1, IIF(Inscope("matrix3_RowGroup2"),True,False), IIF(Inscope("matrix3_RowGroup2"),False,True)) I'm checking to see if the total number of items in the rows are greater than 1. If there is more than 1, I want to display the subtotal, otherwise hide the cell. To get something like this working on different groups, you'll want to add another if statement to first check which group you are in. For example, iif(Fields!myGroup.Value = "Group1", ....... Hope this helps someone. -The Nub