select a field as default in a graph

[#1]

i have a field with 2 value A and B.

i have a list box of this field for selection opportunity that effetcs a sheet completely but  also i have a bar chart that shows this field (A,B)

if nothing is selected in listbox, i want show this graph as selected one value (A) as default only for this graph, if  i select any of these values (A, B) in list box

i want to see both of them

thanks a lot

[#2]

Hi,

Please find the attached doc, hope it helps.

Regards,

Yaseen

[#3]

i need an exp. for this selected field (like your 'year' ) ,this affects not all the sheet but only on one graph. i can see this graph which has selected value, when i see the sheet first time then i can change it with what i select any field.

thanks

[#4]

Hi,

Use the below expression.

SUM({<YEAR=>}NEWVALUE

)

[#5]

hi,

thanks for antwort but i need total opposite of this function.

the selected field ( for exp. year='2013' ) affects complete sheet also the other graphs which i don't will.

this selected field should affect only on one graph.