Reverse of filtering

[jmehul]

Hi,

I want to link a bar chart and a pie chart.
When I select the top customer 'A' from the bar chart, the pie chart should show me the results excluding that top customer 'A'.

For example, the pie chart is showing the country wise share and when the customer 'A' is selected, What is the new country-wise share when a customer 'A' has been excluded.

Thanks 

[FredrikE]

I dont think you can do it with a bar chart.

If you use a list or drop down you can assign a parameter and then create a filter on the pie chart saying customer not equal to [parameter]

//Fredrik

[jmehul]

I have tried using the list but as the no. of customers are too many, it makes the dashboard very messy. 

It is not possible using a drop-down list because when selecting the customer from the drop down it has already filtered the report and now if I create a filter saying customer <> customer_parameter, it will not show any data as everything is being filtered out.

@FredrikE Can you suggest me something which can improve the aesthetics of the dashboard if I go with a list object

[FredrikE · Accepted solution]

Hi!

If the number of customers are to high for the list, how can you fit them in a bar chart....:)

Anyhow, the drop down (or list) should not be placed in the report- nor the section prompt area. Instead it should be placed on the report surface together with the graphs.

By doing that no automatic filtering will occur. Instead you do this by filtering the graph objects with the parameter.

//Fredrik