Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dimension is =ValueList( 'Year 2011','Year 2010') and expression is sum(sales)
i feel this works like it will give separate sales for year 2010 and 2011? am i right?
using sum(Sales) as expression and your dimension you get
the sum of all sales for 'Year 2010'
and the sum of all sales for 'Year 2011'
using sum(Sales) as expression and your dimension you get
the sum of all sales for 'Year 2010'
and the sum of all sales for 'Year 2011'
That expression will give the total of all Sales repeated for each value of the ValueList. Not very useful I imagine.
-Rob