Hi,I need to know how can i hide a one column under a subtotal in a matrix. It contains 2 columns(i need to hide 1). Or how can i change the expression inside the subtotal. i am only able to change the title. It's urgent please

Are you using RS 2005 or RS 2008?It sounds like you are using RS 2005, where this is slightly more complex. For RS 2005, you can use the InScope function to distinguish subtotal cells from other cells. Please check the MSDN documentation about the InScope function:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_0jmt.aspWith InScope you can determine the current scope of a matrix cell (e.g. in subtotal or not). You would use an IIF-expression to set the cell expression based on the InScope return values. Note: a matrix cell is "in scope" of column and row groupings, so you need at least two InScope function calls in the case where you have one dynamic row and one dynamic column grouping. E.g. =iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of ColumnGroup1", "In Subtotal of entire matrix")) For example:Replace "In Cell" with =Sum(Fields!Amount.Value)Replace "In Subtotal..." with =Avg(Fields!Amount.Value) However, note that since the subtotal cells share the same cell definition as the group instance cells, adding two "subtotals" (one for "Total", the other for "AVG") at the same level is not supported. One way of solving this isto add a rectangle into the matrix cell and use two textboxes to show the total and the average. Then use conditional visibility on theaverage textbox to only have it visible for subtotals.Btw, RS 2008 provides a lot more layout flexibility and what you are trying to accomplish is much easier there.HTH,RobertRobert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.

Actually i am using RS2005, you're right.The column group "Restaurant" contains under it two columns (% and Count). When i build the Subtotal column i am getting both columns, but the % is returning wrong values(i don't know why) so i need to hide the % column under subtotal. How can i do it?

I am trying to add a running total to a tablix in RS 2008 and can't seem to get it working. Here is an example of what io want it to look like RENT Date Description Amount Balance 01/01/2010 Balance brought forward £-100.00 £-100.00 01/01/2010 Debit £200.00 £100.00 05/01/2010 Credit £100.00 £0.00 01/02/2010 Debit £200.00 £200.00 05/02/2010 Credit £100.00 £100.00 01/03/2010 Debit £200.00 £300.00 05/03/2010 Credit £100.00 £200.00 NOW() Balance carried forward £200.00 COURT Date Description Amount Balance 01/01/2010 Balance brought forward £-20.00 £-20.00 01/01/2010 Debit £10.00 £-10.00 05/01/2010 Credit £10.00 £-20.00 01/02/2010 Debit £20.00 £0.00 05/02/2010 Credit £10.00 £-10.00 01/03/2010 Debit £20.00 £10.00 05/03/2010 Credit £10.00 £0.00 NOW() Balance carried forward £0.00 COSTS Date Description Amount Balance 01/01/2010 Balance brought forward £10.00 £10.00 01/01/2010 Debit £50.00 £60.00 05/01/2010 Credit £50.00 £10.00 01/02/2010 Debit £20.00 £30.00 05/02/2010 Credit £20.00 £10.00 01/03/2010 Debit £30.00 £40.00 05/03/2010 Credit £40.00 £0.00 NOW() Balance carried forward £0.00 The tablix is grouped by category (eg RENT, COSTS, COURT) and I need to find out how to produce a running balance for each group and put the final palance as an extra row underneath. Any help would be fantastic!!