Ranking in a line chart

[#1]

I am having a problem with ranking in a line chart.  One chart uses this dimension:

=aggr(
if(
rank(
Sum ({$<[As of Date] = {'12/31/2011'}>}
[ICC Counter])) <= 5
  , [Insurance Company Name])
  , [Insurance Company Name])

and it works fine.  It displays the top 5 Companies.

The second chart is exactly the same as the first except it is looking for Companies 6-10 (I am only displaying 5 lines).

=aggr(
if(
rank(
Sum ({$<[As of Date] = {'12/31/2011'}>}
[ICC Counter])) >= 6
  , [Insurance Company Name])
  , [Insurance Company Name])

The result I am getting is the bottom 5 Companies.

If I change the expression to:

=aggr(
if(
rank(
Sum ({$<[As of Date] = {'12/31/2011'}>}
[ICC Counter])) = 6
  , [Insurance Company Name])
  , [Insurance Company Name])

I get the # 6 Company

[pover · Accepted solution]

You should be able to get the result you're looking for if you sort by the expression Sum ({$<[As of Date] = {'12/31/2011'}>} [ICC Counter]) in the line chart in descending order or include in your if-statement the condition that the rank is less than or equal to 10 along with being greater than or equal to 6.

Karl