I need to count number of columns in group

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » I need to count number of columns in group

I need to count number of columns in group

Rate Topic

Display Mode

Topic Options

Author

Message

i hate registration-456225

Posted Saturday, October 16, 2010 10:38 PM

Forum 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 »

Permissions