Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I need to count number of columns in group Expand / Collapse
Author
Message
Posted Saturday, October 16, 2010 10:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 17, 2010 3:41 AM
Points: 2, Visits: 15
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.
Post #1005809
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse