Add subtotal and row counter to a report column in a matrix report

[igor22]

Hi,
I have a matrix report with 3 columns and each column shows a subtotal. There a way to to display a number of rows in the subtotal row along with the subtotal value?

Thanks,
Igor

 

[Catadmin]

Not sure what you're asking. You mean the # of rows it took to get the subtotal?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[igor22]

yes, number of rows

 

[xlbo]

You have a COUNTDISTINCT & RUNNINVALUE function available to you in RS - use that and enter the contexts to count distinct as the row groups in your matrix e.g.

=RUNNINGVALUE(Fields!RowGroup1Name.Value & RowGroup2Name.Value, CountDistinct, Nothing)



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[igor22]

when I am adding RunningValue function to my group expression - i get this error:
A group expression for the 'matrix1' includes the aggregate function RunningValue. RunningValue cannot be used in group expressions.

 

[Catadmin]

See if this thread helps you out any:

thread1462-1074435



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"