Displaying top 5 customers in bar chart

[#1]

How can this be done

I have numerous customers, however, I only want to display the first 5

Thanks

[Anonymous]

use dimension limits tab in chart properties and select option first 5 values

[manojkvrajan]

Attached is the sample application with the bar chart. All you need to do is just restrict the maximum visible bars to 5 and sort the Y axis to descending. I hope this helps.

[#4]

When I restrict the values to the top 5, im given a list of the top 4 customers and then the 5th is an accumulation of all the other customers.

So, for instance, if my sales figure was 100

Cust 1 - 10

Cust 2 - 5

Cust 3 - 3

Cust 4 - 2

Other - 80

This completely distorts the chart.

How can I have the top 5 customers?

Thanks

[#5]

=aggr(if(rank(sum([Order Amount]))<=0,Customer),Customer)

Use something like this as the dimension

[#6 · Accepted solution]

Under Chart Properties > Dimension Limits > Select Show Only Largest 5 Values, then Deselect 'Show Others' under 'Options':

[#7]

Right in front of me (as always!)

Thank you

[#8]

Thank You