Filter selection it will display top 5 values in one chart , another values display in another chart.

[Ramu_i]

Hi All,

I have filter country, When select the one or any country, 

In charts display the top 5 values  one chart, other values display in another chart.

Thanks advance.

[abhijitnalekar]

HI @Ramu_i ,

Are you looking for something like below?

[Tanish · Accepted solution]

Hi Ramu,

In first chart where u need Top 5 value, you can do like this

and then in the Next chart where you need all the values except those top 5, can select Bottom instead of Top and add up expression like this 

Count(distinct customer_city) - 5

 I hope this will work......

You can make this Dynamic as well.

For example - If your first chart shows Top 10 then second chart should show accordingly.

if you need do let me know.