Wednesday, March 7, 2012

How to Add a rowcount in matrix?

hi, there.
I want to add a rowcount in matrix like as..
Accessory 1. Helmet
Bike 1. Mountain Bike
2. Road Bike
Clothing 1. Bib-Short
2. Cap
3. Gloves
4. Jersey
I'm trying a RowNumber() Function..But It Not work Correctly...-.-
Please let me know that..
have a nice day.This looks like you have 2 dynamic row groupings in the matrix. You actually
want a group count and not a row count.
Lets assume the outer grouping has the name "Category" and the inner group
has the name "Product". You would then use the following function in the
group header to get the "group" count:
=RunningValue(1, Sum, "Category") & ". " & Fields!ProductName.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"KwonHyuckSoo" <hskwon@.rey.co.kr> wrote in message
news:exu0TFYkEHA.1028@.TK2MSFTNGP12.phx.gbl...
> hi, there.
> I want to add a rowcount in matrix like as..
>
> Accessory 1. Helmet
> Bike 1. Mountain Bike
> 2. Road Bike
> Clothing 1. Bib-Short
> 2. Cap
> 3. Gloves
> 4. Jersey
>
> I'm trying a RowNumber() Function..But It Not work Correctly...-.-
> Please let me know that..
> have a nice day.
>

No comments:

Post a Comment