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?
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.
It worked..thanks for the quick answer.
easy as take candies from a child... :-)
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.
Retrieving data ...