how to grand total manually

siraj_farooq

<p>i have used grand total in row area to total numbers..now i want another grandtotal that can display same data...and want to show both grand totals at the same time</p><p> </p>

BRM

<p>There are a few ways to do this depending on what your needs are:</p><p>If the second grand total can be displayed in the footer of the main table than you can add lines to the footer and/or grids and whatever you need to set it apart and simply add another aggregation element.</p><p> </p><p>If the second GT needs to display the total of some other slice of data you can use a filter in the aggregation element</p><p> </p><p>If the GT need to be somewhere else on the report the isn't close to the main table then you could set a persistent global variable to allow the GT to be retrieved and placed in the second place.</p><p> </p><p>The other thing you could do would be to add a new table in the second location and hide everything except the footer where you place the GT element.  The second table is bound the the same dataset as the first.</p><p> </p><p>Hope some of that helps.</p>