Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsTop 3 report
https://www.eclipse.org/forums/index.php/mv/msg/220869/697084/#msg_697084
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?
Thanks]]>sam va2011-07-15T13:38:08-00:00Re: Top 3 report
https://www.eclipse.org/forums/index.php/mv/msg/220869/697092/#msg_697092
This is how I have done.
1) Hide all the rows after row 3
2) Add 2 rows in the footer.
One will aggregate all the values from row 4 to row 10
One will aggregate all values