Dynamic Amount of Shown Values.

[#1]

Hello,

I'm having some trouble with a Fast Change chart that is a pie and a bar chart.

The thing is that when im at the bar chart i would like to see the biggest 10 values without an other option, but in the pie i would like to see the 5 max values and a 6th one of others to make my 100%.

I was looking for a way to use in the dimension limit section a function that would get me a char type so i could limit the dimension and the others, but i havent found a function yet.

Is there a way to do this differently?

thanks guys,

[Gysbert_Wassenaar]

That's not possible with only one chart object. You'll have to create more charts and show/hide them as needed using the Conditional display option on the Layout tab of the properties window of the charts.