if condition how it works here?

[#1]

if(  ValueList( 'Year 2011','Year 2010') = 'Year 2011',

  sum( {$<Year={2011}>} Sales),

  sum( {$<Year={2010}>} Sales)

)

how it works?

[maxgro]

bar chart

synthetic dimension is ValueList('Year 2011','Year 2010')

expression is your expression

[#3 · Accepted solution]

if(  ValueList( 'Year 2011','Year 2010') = 'Year 2011',   sum( {$<Year={2011}>} Sales),

if(  ValueList( 'Year 2011','Year 2010') = 'Year 2010',    sum( {$<Year={2010}>} Sales) )      this is the result right

[ashfaq_haseeb]

Yes this is right.

Regards

ASHFAQ