Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2010-10-17 : 00:41:45
|
| hello,I need to count number of columns in group -I have a matrix with SUM in the date area.I have a group column (lats say 'city') and under it my columns (lats say 'street name');Under each 'street name' I have cell with SUM function.The problem is:When The main group (city) is not expand I get the sum of all cities and what I want to get is an average.So what I thought of was to divide that number in the number of streets under each city group.How can I get that number?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 03:34:02
|
| you can use Count(Fields!YourField.value,"city group name here")------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 03:35:01
|
| for average did you try to use Avg() ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
I need to count number of columns in group