Using Pick function without any other functions

[Sai_Mohan]

Hi All,

How can i write pick function without giving any other condition with that ?

Example:

I have 3 toggle buttons, i need to activate that with pick function.

If i click on one button, changes should be applied for the  three charts (barchart, line chart, pie chart).

I have used  pick function 

=pick(var1,[Worldwide],[Region],[Customer])>> it is giving error like bad field name 

can someone help me out with this

Thanks

Sai

[marcus_sommer · Accepted solution]

var1 might be better declared as $(var1) - also it should contain numeric values. In your example 1 or 2 or 3.

- Marcus

[Sai_Mohan]

Thank you Marcus.