Linking Listbox with charts

[#1]

Hello,

I have a list box with multiple items in it for e.g.

- Percent of xyz

- Percent of abc

And I have a chart for each of these percents depicting Current Year vs. Prior Year.

So when I select "Percent of xyz" I would like to only see the chart for it and the other chart should say "No data to display"

Please advise. Thanks!

[AbhijitBansode · Accepted solution]

For both the charts, Set the calculation condition from the General tab:

for first chart :

if(GetFieldSelections(ListBoxFieldName)='Percent of xyz',1,0)

for second chart

if(GetFieldSelections(ListBoxFieldName)='Percent of abc',1,0)

[#3]

You're the God! Thanks man!!! Shall keep you posted if I bump into more roadblocks.

[#4]

So far the following has been achieved:

When I select "Percent of xyz" from the list box I would see it's chart

When I select "Percent of abc" I would see it's chart

However, what I want is that the chart for xyz minimizes. How to do so? Thanks!

Regards