Crosstab Query with Second Intersecting Value?

[nstouffer]

I am trying to create a resulting crosstab or pivotfield
query that will give me a second value at each intersection. I can get the single cross-tab query ok, but having trouble with the second value. The resulting set will be used to graph an opportunity or bubble chart. Example:crosstab query results:

[Complexity]xvalues
......................................................
[Project Name "a"] [NPV Value ]yvalues
.......................................................
[Project Name "a"] [Resources ]bubblesize
.......................................................

So,

Column Hd -> 2 7 8 9 (used as x-values)
Row Heading:
Blue Hats 5 (used as y-values)
Blue Hats 2 (Used as Bubble size)

Red Shirts 7
Red Shirts 3

Yellow socks 9
Yellow socks 1

Orange Pants 6
Orange Pants 3

Has anyone had experience in creating this type of cross-tab
in SQL Statements?

Thanks for your help.

 

[mbevon]

I wish you luck.
What i did was create two crosstab then join them with a Select query.

Good luck