Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Use Country as Your dimension and change the Expression to
SUM({<Country = {'USA','UK','FRANCE','JAPAN'}>}Sales)
Choose the countries what you want in the chart and writhe the expression as SUM({<Country = {'USA','UK','FRANCE','JAPAN'}>}Sales)