September 1, 2009 at 3:13 pm
I have create one Matrix Report, it has a Column grouping on Month and Row grouping also on Month. In the row grouping there are three rows, suppose name A, B, C. I addedd One Subtotal field at the Right (Horizontal summation) and at Bottom (Vertical Summation). But in the horizontal Subtotal I want to show the summation value for only Row C. I want to some how hide the summation for row A and Row B. Currently Subtotal field shows sum for every row.
September 2, 2009 at 12:15 pm
Hi There..
I have few questions...
If A,B,C row values and do u know what the last value thatis C in that order....
If yes then using expressions u can control whether to show or not the summation...
say
Iff(fields!row.value=c,Sum(Value),"")
something like this should work...
cheers
satish
September 2, 2009 at 12:24 pm
Value in the Row C is dynamic and it is changing for each set of group..
September 3, 2009 at 3:44 am
can you do an ordering in your query on the column containing the a,b,c data and in the expression u can use
if rowvalue = max(Column) then...
This will work if your column is number, string or date
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply