Classification crosstab query - 2000

[L Mehl]

Hello --

I think this is the term for what I want (something that could be generated
in ACCESS using a pivot table, or, maybe Yukon).

We have data for sales by sales people in sales regions. More than one
person sells in a region.

We want to display data as follows:

salesperson's names
----------- ----------- ----------- ----------- ----------
- -----------
region 1
region 2 row/column values are sales amounts for person in
that region
region 3

We will add a WHERE clause for the period of time covered.

I don't want to have to change the query if a new salesperson or new region
is added.

Can this be done in SQL Server 2000, Analysis Services, OLAP, anywhere?

Can someone direct me to examples of how to do this?

Thanks for any direction.

Larry Mehl

[John Bell]

Hi

This previous post should help:
http://tinyurl.com/6rhsj

John

"L Mehl" <me*********@cyvest.com> wrote in message
news:96*****************@newsread3.news.pas.earthl ink.net...

Hello --

I think this is the term for what I want (something that could be
generated
in ACCESS using a pivot table, or, maybe Yukon).

We have data for sales by sales people in sales regions. More than one
person sells in a region.

We want to display data as follows:

salesperson's names
----------- ----------- ----------- ----------- ----------
- -----------
region 1
region 2 row/column values are sales amounts for person
in
that region
region 3

We will add a WHERE clause for the period of time covered.

I don't want to have to change the query if a new salesperson or new
region
is added.

Can this be done in SQL Server 2000, Analysis Services, OLAP, anywhere?

Can someone direct me to examples of how to do this?

Thanks for any direction.

Larry Mehl

[L Mehl]

John --

Thanks for pointing me to this article.

It worked right out of the box.

Larry
"John Bell" <jb************@hotmail.com> wrote in message
news:41***********************@news.easynet.co.uk. ..

Hi

This previous post should help:
http://tinyurl.com/6rhsj

John

"L Mehl" <me*********@cyvest.com> wrote in message
news:96*****************@newsread3.news.pas.earthl ink.net...

Hello --

I think this is the term for what I want (something that could be
generated
in ACCESS using a pivot table, or, maybe Yukon).

We have data for sales by sales people in sales regions. More than one
person sells in a region.

We want to display data as follows:

salesperson's names

----------- ----------- ----------- ----------- ---------

-

- -----------
region 1
region 2 row/column values are sales amounts for person
in
that region
region 3

We will add a WHERE clause for the period of time covered.

I don't want to have to change the query if a new salesperson or new
region
is added.

Can this be done in SQL Server 2000, Analysis Services, OLAP, anywhere?

Can someone direct me to examples of how to do this?

Thanks for any direction.

Larry Mehl