Rank duplicates

[missspeedy23]

I need to do a top 10 in a report but because a lot of the values in the list are the same value (and therefore rank 5) it's showing a lot more than 10 rows in my list. Is there any way to force cognos to see each of these values as a unique rank number and therefore stop at row 10? I have tried various rank x for y and it's set to filter after auto aggregation but nothing I've tried seems to work. (See attached example).

[Lynn]

You could ask the business user if the basis for ranking is sensible given so many ties in the ranking.

You could try using a running-count function to limit the list to 10 which would force a limit on the list although it is somewhat arbitrary.

[missspeedy23]

Thanks for the advice, that does what I need it to do but I agree on the data.

[AnalyticsWithJay]

You have to take your rank query and feed it to a new parent query so that it becomes a subquery. The parent query will have all the data items of the subquery.

On the parent query, set the Aggregate Function property for 'Customer Name' to Maximum or Minimum, to retrieve the first or last value. This will eliminate duplicates.

On the parent query, set the aggregate function on your Rank data item to none.