Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please find the attached doc, hope it helps.
Regards,
Yaseen
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
Hi,
Use the below expression.
SUM({<YEAR=>}NEWVALUE
)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.