Multile lines in line chart with columns a b c

[rammiee93]

I can able to create with the types not with the years. How to create  multiple lines with years as columnd

@Kushal_Chawda 

[Kushal_Chawda]

@rammiee93  create line chart with two dimensions

Add Year as "Group" Dimension and type as "Line" Dimension .

Then use your measure eg sum(value)

[rammiee93]

This is what I got so far. I couldn't able to figure out the part of the measure.  @Kushal_Chawda 

[rammiee93]

@Kushal_Chawda  Any help on this?

[Kushal_Chawda]

@rammiee93  Why you have used valuelist? You can directly add Year field itself

[rammiee93]

There is no field called Year, each year is a column

[Kushal_Chawda · Accepted solution]

@rammiee93  I see. Then you may need to transform your data to row and column format using cross table

// Here * means all the fields displayed as Year. So try to include other columns at top and use * to represent all Year field which you want to trasnform

CrossTable(Year,Value)
Load Type,
     *
FROM Source;

if you have few more columns in data, you can update your code

CrossTable(Year,Value,3)
Load Type,
     Field1,
     Field2,
     *
FROM Source;

Now , create line chart with two dimensions

Add Year as "Group" Dimension and type as "Line" Dimension .

Then use your measure eg sum(value)