IF i tap on the button it should exclude the values from chart.

[syedmazhar]

Suppose  i have a country column and i have added a button on the top to filter in the chart.

EXM: When i open the report all the country's values should be displayed and when i tap on the button some of the country's should be excluded. 

1. India

2.USA

3.Japan

4.China

5.Russia

6.UAE

after i tap on exclude button(Exclude China,India,Japan).

Result:

1.USA

2.Russia

3.UAE

Please help me to achieve this.

Thanks in Advance.

[chrismarlow]

Hi,

Manually apply your selections/exclusions and save a bookmark (bookmarks - add bookmark).

Add a button (new sheet object - button), add an through the actions tab of the properties of the button to apply the bookmark (add action, bookmark, apply bookmark, bookmark id).

Cheers,

Chris.

[syedmazhar]

Can this be done using variables?I have some 500 values to exclude from more the 2k records.

Is there any other way to implement this functionality.

Thanks  in advance.

[chrismarlow]

Hi,

So I am assuming you don't have 2k different countries, rather you are looking at a table with 2k rows where country is a dimension … .

You should add a list box for the country field and make the selection through that. If you have a long list to apply you can use advanced search, so from the example you gave;

You can then save your bookmark & add to the button.

Hope that helps.

Cheers,

Chris.