Two dimensions in a crosstable

[#1]

I don't know how to make one dimension appear crosstabulated with another. The numbers I am looking for is the aggregated numbers in percent.  Also the coloring is a bit of an issue as it is ( se picture) though I have the RGB values

Translation:

Klasse = Class

Volum = Volume

Andel = Share

Tilgang = New

Avgang = Drop outs

Mislighold / Misl. = In breach

Uklassifisert = Unclassified

Ned = Down

Uforandret = Unchanged

Opp = Up

So the main issue is how to hook on the A / B/ C... because it is the values in another variable.

[jaspal_icon]

Hi there,

Explain your problem in detail, also attach some sample data or sample qvw file which can explain what the desired result you are looking for.

Regards

Jaspal

[#3]

Hi there,

I have this data to work with, see included file.

So I want the data to appear like in the included picture in the first post.

Where Klasse = m3_Klasse and the (A, B, C, D, E, F, G, Misl., Ny) are the values that the variable Klasse might have. I want to try to crosstabulate those values with the dimension m3_Klasse

Update:

I have manged to load the data in as a crosstable, but I now wonder which chart type will give me the representation that I am seeking.

           Klasse_A_sum      Klasse_B_sum      Klasse_C_sum      Klasse_D_sum      Klasse_E_sum etc...

A                   5401 (xx%)     64 (x%)               25(x%)                                                  1(x%)

B                    62(x%)          1811(xx%)          45(x%)                    11(x%)                    2(x%)

C                    30(x%)               77(x%)          1969(xx%)               etc....

D

E
F

G

[#4]

I have manged to get the data like I wanted it, but now the question how do I import the numbers simply from a table, now I just typed in the numbers.

[christian77 · Accepted solution]

Hi:

Try pivoting. Drag the column as shown.