hidding columns

[#1]

hi all,

i have a question about hidding columns.

this is what i did, i know that i am in the right direction but i am dont know what is wrong:

this is my list box:

list box: Hide BY

GETSelectedcount(cost)=1

GETSelectedcount(clicks)=1

i set new variable called VshowCOST:

=GetFieldSelections("Hide By")

in the main chart properties i put a condition with the variable $(VshowCOST)

when i click in the list box on one of the items, both columns(cost and clicks) are dissapearing and i want only what the user is choosing hidden.

what is the problem?

thank you

[Anonymous]

Hi

     If you can please attached some example file . is used  to understand your requirement clearly

Regards

[#3]

Hi,

It seems to me that now whatever you're choosing in the Hide By listbox - if the condition is true it's true for both of your columns, and therefore both of them are hidden.

If I understood what you need correctly, I would load in the Hide By listbox:

costs

clicks

and then in the table put the following conditions for the columns:

clikcs: $(VshowCOST)='clicks'

cost: $(VshowCOST)='cost'

Please let me know if I misunderstood you

[Anonymous]

Hi

Hope the following attached file will be helpful for your requirement

Regards

Ashok

[#5]

i succeded to do it with button,

i set variable "VshowCost" = 0

and in chart properties i give condition:

=GetSelectedCount($Field)=vShowCost

in the button i set variable : VshowCost

value: 1

and now it work but i still cant do it in the list box.

thank you all for the help

eran