Filter dimensions in pie chart

[anuradhaa]

Hi,

I have country as a dimension. and i have created sales by country pie chart.

But now i want to get sales by specific countries,

say "USA","UK","FRANCE","JAPAN".

Please tell me how to do that.

Thank in advance

[Gysbert_Wassenaar · Accepted solution]

1. Add a listbox (or multibox) with the country field and select the countries you want in the listbox (or multibox).

2. Change the expression in the pie chart. For example change sum(Sales) to sum({<country={'USA','UK','FRANCE','JAPAN'}>}Sales) to make the expression filter the countries to those listed.

[rustyfishbones]

Use Country as Your dimension and change the Expression to

SUM({<Country = {'USA','UK','FRANCE','JAPAN'}>}Sales)

[#4]

Choose the countries what you want in the chart and writhe the expression as   SUM({<Country = {'USA','UK','FRANCE','JAPAN'}>}Sales)