I want make an overview related to the TOP N customers. I created a slider to select the TOP N customer with a variable. On the dimension i created the following calculated dimension:
This works fine. But now i want creat an another overview that is based on the TOP N customers. For example if i select TOP 10 customers i want see the sale values per region in a pie chart based on the TOP 10 customers.
Have somebody any idea how i can create this overview?
In a pie chart, go to the presentation tab and set the Maximum Number of Slices, you can do this simply by adding your variable to the expression. The control of wether you see Top or Bottom is then down to the sort value.
Thanks for your response. I have the following situation. I have 1 bar chart object which i show the TOP N customer. But i want know a second object (=pie chart) which i want show the sales values per region based on the top N selection that i made on the first bar chart object. In your case, the setting of the Maximum Number of Slices generic for the available dimension. I tried to put the customer on the dimension and calculated the TOP N with als the region on the dimension. But in the pie chart i don't want see the customer and you have also no possibilty to hide the dimension in the pie chart.
