|Top 3 report [message #697084]
||Fri, 15 July 2011 09:38
| sam va
Registered: July 2011
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.
any way to achieve this?
Powered by FUDForum
. Page generated in 0.01793 seconds