TopN Sort with Others

[msanders67]

I have a report - MTD Top 20 Customers based on sales figures. I have three groups set up to get a total for some combined like accouts. IE: I have several accounts that are similar who's sales need to be combined for this report. That all works great, but I then apply the TopN sort to get the top 19 customers based on the sales figures that are combined into the first group's total. However, instead of getting the other's - #20 and beyond combined into "others" it's picking up the first customer's account and using that for the display name. Here is the group formula I'm using to combine the like customers:

IF {AR1_CustomerMaster.SortField}>" " THEN {AR1_CustomerMaster.SortField}
ELSE {AR1_CustomerMaster.CustomerName}

Why is it pulling the 20th customer in the ranking and using that as the display instead of the word "Others" which is what I've set up in the TopN sort?

Thanks in advance for your help!
Margo

 

[JBBJWS]

Make sure you are displaying the group name field rather than the customer name field.