I have a horizontal stacked bar graph and want to limit it to just the top 10 sums by Y-axis category.
The data has a year's worth of customer orders. Each row is an order line item that has a customer, a value and a customer country (among other data). The x-axis is summary statistic sum of the order value. The y-axis is the customer name. And the stacking (overlay) is by the customer country.
My goal is to not show all 1,000 customers, but rather just the top 10 by the total of their order values.
The script at the moment looks like this, where sales org. is the customer country