Hi,<br />
<br />
I think what I need is a crosstab, but with static rows. I am looking for something like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
1 2 3 4 5....
Speed 22 12 44 0 0
Colour R W W B -
Height 2 2 2 3 2
Weight 21 23 21 26 22</pre>
<br />
Where the numbers in the top row are dynamic, and the row "headers" (Speed etc) are static. Using a crosstab and data cube, I can produce this:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
1 2 3 4 5....
22 12 44 0 0
R W W B -
2 2 2 3 2
21 23 21 26 22</pre>
But I really need the labels.. Do you have any ideas how to achieve this?<br />
<br />
Or should I use a table instead. This is table data really, but with the table on it side....<br />
<br />
Thanks in advance,<br />
Stephen
