https://communities.sas.com/t5/SAS-Web-Report-Studio/Top-20-List-with-other-sum/m-p/18860#M257 I think you have two options on this.<BR /> 1. Create a stored process that generates the data results or the report.<BR /> 2. Utilize calculated data elements within Information Map Studio to generate the results.<BR /> <BR /> The stored process is probably the most straightforward way. Here is an example:<BR /> <A href="http://support.sas.com/kb/26/175.html" target="_blank">http://support.sas.com/kb/26/175.html</A><BR /> <BR /> ~ Angela Wed, 22 Jun 2011 13:59:36 GMT AngelaHall 2011-06-22T13:59:36Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Top-20-List-with-other-sum/m-p/18859#M256 Hello,<BR /> <BR /> I´ve got a question for a WRS Report.<BR /> My customer wants a report which shows a Top 20 List + a sum of all others and an grand total.<BR /> Like this<BR /> <BR /> Customer Revenue<BR /> 1 100<BR /> 2 99<BR /> 3 98<BR /> ..<BR /> 20 80<BR /> all others 200<BR /> total 2090<BR /> <BR /> I did not found a solution in WRS<BR /> Thanks for your comments<BR /> Thomas Wed, 22 Jun 2011 12:04:19 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Top-20-List-with-other-sum/m-p/18859#M256 gertbd 2011-06-22T12:04:19Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Top-20-List-with-other-sum/m-p/18860#M257 I think you have two options on this.<BR /> 1. Create a stored process that generates the data results or the report.<BR /> 2. Utilize calculated data elements within Information Map Studio to generate the results.<BR /> <BR /> The stored process is probably the most straightforward way. Here is an example:<BR /> <A href="http://support.sas.com/kb/26/175.html" target="_blank">http://support.sas.com/kb/26/175.html</A><BR /> <BR /> ~ Angela Wed, 22 Jun 2011 13:59:36 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Top-20-List-with-other-sum/m-p/18860#M257 AngelaHall 2011-06-22T13:59:36Z