I have developed a report that lists the annual volume of business with our Suppliers (annual PO Value). To focus on the Top 20 suppliers, I used a Top N report showing the group totals.
Since the Supplier Number is the key to the record, I put the Supplier Name in the Group Footer alongside each Supplier Number. There are also totals, other than PO Value, in the Group Footer section.
If I include Others in the Top N, I get the next Supplier Name, as well as a bunch of numbers in the other columns that I do not understand.
How can I blank out the Supplier Name when Others is the last line in the Top N report? How can I blank out the other numbers in the columns other than the column used for the Top N calculation?