By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

Classification crosstab query - 2000

P: n/a
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
Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 23 '05 #2

P: n/a
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


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.