Line Chart for Multiple Categories

[#1]

Hello!

I have the following Simple Table:

Category	Jan	Feb	Mar	Jun	Jul	Aug	Sep	Oct	Nov	Dec
001	30	45	20	50	55	60	85	70	40	55
002	15	20	25	30	20	65	75	90	80	85
003	35	40	50	70	60	50	70	80	90	95

Where Category is a Dimension and Jan/Feb/Mar are Expressions.

What I want is to create a Line Chart where every line should be a different Category.

For example: I should have a line for Category 1 where values are 30, 45, 20.

X Axis: Categories by Month

Y Axis: Values (30, 45, 20)

Do you know how could I do this?

Thank you!

[datanibbler]

Hi mart,

for that you'd have to turn it around and have the months as dimension and the categories as expressions - one line represents one expression running along a dimension, so if your months are your dimension, you can have three expressions = three lines.

HTH

Best regards,

DataNibbler

[#3]

Thanks for your answer.

But I don't know how many Categories could I have because it depends on those who are imported from a QVD and it also depends on the selected date, that's where the value vary and also the Categories shown.

[Gysbert_Wassenaar]

It can't be done with the months as expressions. If you use more than one expression then each expression will get a line. What you can do if your source data is in the format you posted is use the Crosstable function to transform the data and create a Month field. See attached example.

[#5]

Can you attach a sample file for analysis, if possible?