Skip to Content
0
Former Member
Mar 01, 2011 at 07:08 AM

can crosstab show multiple objects in top header?

619 Views

can crosstab show multiple objects in top header?

for example, the data showed as :

customer  city name  city value	 product name  product value
    A	        Paris	     1	        food	         N
    A	        London	     2	        milk	         T
    B	        London	     3	        food	         E
    B	        Paris	     4	        milk	         M
    C	        London	     6	        food	         W
    C	        Paris	     3	        milk	         Q
    D	        London	     1	        food	         E
    D	        Paris	     2	        milk	         R

i want show these data in crosstab, and customer is the left header, city name and product name are the top header, and city value and product value are measures in the crosstab,

and i want show the data as below:

	London	Paris	food	milk
A	2	1	N	T
B	3	4	E	M
C	6	3	W	Q
D	1	2	E	R

but actually i got below result in crosstab:

	London	food	London	milk	Paris	food	Paris	milk	
A			2	T	1	N			
B	3	E					4	M	
C	6	W					3	Q	
D	1	E					2	R	

anyone can help me on this?

thanks.