trying to create a line chart with 2 expressions and I want a line to be drawn

[#1]

Hi, I am trying to create a line chart with one dimension as Year. I have got 2 expressions 1 for YTD current year and 1 for YTD last year. They are completely different expressions. When I do the line chart they appear as 2 dots and the line is not drawn between them. And obviously as these are 2 different expressions. Is there any workaround to draw the line. I want to show the movement from 2012 to 2013. Any chart will do if it can accomodate my requirement.

Thanks,

Ram

[MayilVahanan]

Hi

You can use bar chart or pivot/Straight table.

hope that helps

[Gysbert_Wassenaar]

Replace your two expressions with one expression: if(Year=2012, ...2012-expression-here..., ...2013-expression-here...).

[#4]

=if([Field1]='$(lvYear)',(Sum( {1<[Field1]={'$(lvYear)'}>} [Retail Net]))/1000000, (Sum( {1<[Field1]={'$(lvPrevYear)'}>} [Retail Net]))/1000000)

I tried, but this doesn't work.