Top 10

[#1]

Hi,

I have a list of Customer, Target and Invoice Total

I want to display the top 10 customers by invoice Total and I have used the dimension limits and this has grouped as I want all the top 10 customers and an other section. However, to do this correctly Invoice has be listed first in the expression.

Is there a way round this

[sunny_talwar]

You can use Rank function with Aggregate function, but that can effect performance

[#3]

will this allow me to have a group of others though.

[sunny_talwar]

Do you have a particular example, I am not really sure I understand what you mean when you say group of others?

UPDATE: I see what you mean, I believe you can still create that with little manipulation

[#5]

I have created and additional invoice total and put that as the first expression and then hidden it