sql server reporting services: Average Expression ?? -- sql server reporting services

Average Expression ??

Vishal
12/23/2005 5:03:49 PM

sql server reporting services:

Hi,

I want to calculate the Average Sales for given columns, eg

Jan Fab Mar April AVERAGE
100 100 100 100 100
20 20 10 15.66
30 10 50 30

Is it possible using an Expression ?

Thanks

RE: Average Expression ??

Wayne Snyder
12/26/2005 4:45:02 AM

Create a matrix report and change the aggregate from Sum to avg
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.