Cross Tab: Multi Column data?

Hello,

How do you use the cross tab tool to select more than one data item to
be summarized for the columns?

What I would like to do is select two fields for data, based on the
same column.

My (simplified) table is laid out like:
NAME (C), PERCENT (N), VALUE (N)

E.g. sample data:
FRED, 50%, 12
JOHN, 60%, 16
BOB, 12%, 20

For each "NAME", I would like to see the 'PERCENT", and "VALUE".

E.g. :

FRED % | FRED value | JOHN % | JOHN value | BOB % | BOB value
50 12 60 16 12
20

I hope this makes sense.

Thank you!

Anders
Wed Nov 30 01:51:18 CST 2005

Where are you column headers?
Do two crosstabs and join them.

Anders

<drsystems@gmail.com> skrev i meddelandet
news:1133308000.099305.156960@g49g2000cwa.googlegroups.com...
> Hello,
>
> How do you use the cross tab tool to select more than one data item to
> be summarized for the columns?
>
> What I would like to do is select two fields for data, based on the
> same column.
>
> My (simplified) table is laid out like:
> NAME (C), PERCENT (N), VALUE (N)
>
> E.g. sample data:
> FRED, 50%, 12
> JOHN, 60%, 16
> BOB, 12%, 20
>
> For each "NAME", I would like to see the 'PERCENT", and "VALUE".
>
> E.g. :
>
> FRED % | FRED value | JOHN % | JOHN value | BOB % | BOB value
> 50 12 60 16 12
> 20
>
> I hope this makes sense.
>
> Thank you!
>

drsystems
Wed Nov 30 10:32:15 CST 2005

Thanks for the reply
I know I can do two cross tabs, and join them, but I want the order of
the columns to be:
Percent, Value, Percent, Value...

Not, Percent, Percent, Percent, Value, Value, Value