Show only the top 10 Customers

[#1]

Hello,

I have a bar chart that load the customers and their amount bought and I would like to show in the bars only the top 10 customers.

Is there any configuration that I can set to only show those customers?

Can i restrict it only by formula?

Thanks,

Oscar

[#2 · Accepted solution]

Hi

Go to Chart properties, Sort, and sort the Customers by Y-value descending.
Then go to the Presentation tab and set the property "Max visible number" to 10. That should do it.

/Fredrik

[#3]

Hello,

In your graph properties , go into the presentation tab and check the 'Max Visible Number' , put 10 in the number and that should be it.

philippe

[#4]

It worked..thanks for the quick answer.

easy as take candies from a child... 🙂