Search and conditional display of graph

[#1]

Hi:

I have placed a search object on my sheet.

I want that when user search for a particular data item then chart for that data item is displayed.

For e.g.  my search has only Regions, when user search/select for Region CA,

then chart showing revenue of CA should be displayed.

When user search/select MA then revenue of MA should be displayed.

Can you please tell me how can do this.

Thanks.

[eliran · Accepted solution]

The search object is a bit irrelevant to this issue, it's more of a display thing and I'll explain.

You can use a conditional rule on the object you wish to display for one region only.

In the chart properties go to General tab, then go to calculation condition and type:

Count(Distinct RegionField)=1

Meaning, only display the chart if one region is selected.

How can the user select? either by a list box, or by a search object as you wanted before.

Hope it helps,

Eliran.

[#3]

Eliran:

It worked.

Thanks.