I have a report where it displays the top 3 items and the 4th row will be a sum of all the rest of the rows.
The query is
Select item_count, amount From table1
If the query returns less than 4, it will display those details.
In case the query returns more than 3 rows, lets assume 10 for now, the first 3 rows will be displayed as is, but the 4th row will be sum of all the rows from 4 thru 10.