Selecting on string variable

[#1]

Basically, I want a chart to be displayed for just one value in a string variable i.e. if SESYEAR='2009'.

Also, where is such a selection (condition) placed ?  The General tab?

Any help,

Gratefully received

Racine62

[swuehl]

Go to Layout tab in chart properties and enter as 'Show' conditional expression in the appropriate field:

SESYEAR='2009'

[#3]

Thanks for responding.  I've not explained myself very well.

Basically, I want a separate chart for each year (2009 to 2013) and for them to on display all the time, not just when they are selected.

Regards,

Racine62

[swuehl]

Ok, let's assume you create a chart with dimension Customer and you want to show Sales for the different year.

Create 4  charts each with dimension Customer and then using 1 expression for the first

=sum({<SESYEAR = {'2009'} >} Sales)

resp.

=sum({<SESYEAR = {'2010'} >} Sales)

=sum({<SESYEAR = {'2011'} >} Sales)

=sum({<SESYEAR = {'2012'} >} Sales)

=sum({<SESYEAR = {'2013'} >} Sales)

for the other ones (where SESYEAR is your sales year field).

Hope this helps,

Stefan