crosstables and graphics

[#1]

Hello!

I have a crosstable with this aspect (more or less)

Country               August               September

Spain                    23                         14

Germany               48                         98

England                 27                         27

Italy                       87                        14

France                   21                        74

I need to represent it in a bars graph, with a expresion corresponding to August and other expresion whit September. The dimensions must be the countries.

How can I do this???

Regards.

[#2]

Hi,

You just need to make a graph with in the dimenseions 'countries' and in the expressions the two columns.

What is exactly the problem?

[#3]

Hi.

The problem is that I don´t know what expresions to use to select only the values corresponding to August and the values only corresponding to September. I´ve tried if(month='August',Data), but it doesn´t work. It works only when i select the month in a list, but I need that it shows the graph together without selecting anything.

Thanks.

[#4]

You only have to add the two columns in the expressions, see image:

[#5]

Hi,

Please find the attachment.

Hope this one helps you.

Regards,

Kabilan K.

[#6]

OK, I´ve made it, but without loading it as a crosstable.

Thanks for all, and sorry for this stupid question

[#7]

I think you have to reorder your input, e.g. like this:

LOAD * INLINE [
    Country, Data, Month
    Spain, 23, August
    Germany, 48, August
    England, 27, August
    Italy, 87, August
    France, 21, August
    Spain, 14, September
    Germany, 98, September
    England, 27, September
    Italy, 14, September
    France, 74, September
];

In the graph enter as dimension Country and Month.

[#8]

I forgot the reason why i´ve loaded it as a crosstable. The problem is that the file will grow up. New months will be added, and the idea is that only reloading the excel file, the graph will be autogererate by itself, each month in a new group of columns. I don´t know if it is possible to do.