Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Eliran:
It worked.
Thanks.