Help with set analys

[#1]

Hello!

I have a variable that we can call "variable" which has several different variables mounths. But I would just like to read Varable A values ​​for January-December. How do I do it in the best way?

For example

Variable	Jan	Feb	Mar	Apr
A	1	1	1	1
B	2	2	2	2
C	3	3	3	3
D	4	4	4	4
E	5	5	5	5
F	6	6	6	6

[#2]

Hai,

I unnderstood u r requirement

pls shere any sample file

Thanks&Regards,

chandu

[#3]

Hello!

I've created a file where I have removed the variable names and framed letters instead, hope that you understand the material. What I therefore would like to show is therefore, digits for only var1 A - Var2 A, row 3, for example,

And I think I have to load the data set in this way because I have a lot of other varitabler I've taken away from this, and I want to be able to roll lists on var1 and Var2

[fosuzuki]

Is this what you want to do?

CrossTable(Month, Value, 2)

LOAD Var1,

     Var2,

     Januari,

     Februari,

     Mars,

     April,

     Maj,

     Juni,

     Juli,

     Augusti,

     September,

     Oktober,

     November,

     December

FROM

Examlpe.xlsx

(ooxml, embedded labels, table is Blad1);

[#5]

Hello!

I want to make a line graph with only ensast values ​​of a variable in var1 and Var2. Type number three in the Excel file, A and A.

[fosuzuki]

What about this:

CrossTable(Month, Value, 2)

LOAD Var1,

     Var2,

     Januari,

     Februari,

     Mars,

     April,

     Maj,

     Juni,

     Juli,

     Augusti,

     September,

     Oktober,

     November,

     December

FROM

Examlpe.xlsx

(ooxml, embedded labels, table is Blad1)

Where Var1 = 'A' and Var2 = 'A';