Column Groups : Help with Matrix Report

I have a table that has 2 colums
Project Probablity
1 15
2 89
3 12
4 22
5 7
6 11
7 43
8 92
9 63
10 87
...n ...n
I have to show report that has to show the no. of projects that fall
in the probability 1-10,11-20,21-30,...,91-100
I want to show it in a matrix, Iam just confused about the column
groups and row groups. Can someone hint me how i can achieve this in
matrix ?
thanks
anand sagarYou can group on an expression like this:
=Ceiling(Fields!Probability.Value/10)
And then show this calculation: Count(Fields!Project.Value)
I'm not sure why you want to show this in a matrix since there's only one
axis. I'm assuming that's because you want it to be displayed horizontally.
For that, you would need the row grouping to be static. See this blog entry
for more details:
http://blogs.msdn.com/chrishays/archive/2004/07/23/193292.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Anand Sagar" <anandsagar@.gmail.com> wrote in message
news:3f76a771.0408300414.50d12d6b@.posting.google.com...
> I have a table that has 2 colums
> Project Probablity
> 1 15
> 2 89
> 3 12
> 4 22
> 5 7
> 6 11
> 7 43
> 8 92
> 9 63
> 10 87
> ...n ...n
>
> I have to show report that has to show the no. of projects that fall
> in the probability 1-10,11-20,21-30,...,91-100
> I want to show it in a matrix, Iam just confused about the column
> groups and row groups. Can someone hint me how i can achieve this in
> matrix ?
>
> thanks
> anand sagar