<p>Hi,</p>
<p>I am new to BIRT report designing. I am facing a problem in displaying aggregate data. I am attaching a sample report design file (Sample.rptdesign) and its data set (SampleData.xml) and explaining the requirement here.</p>
<p> </p>
<p>As seen in the report in the first table there are records like :</p>
<p> </p>
<div>Column 1</div>
<div>Column 2</div>
<div style="text-align:center;">Column 3</div>
<div>Count</div>
<div style="text-align:center;">Pune</div>
<div>ABXD</div>
<div>Master Card</div>
<div style="text-align:center;">10</div>
<div>RFBG</div>
<div>Visa</div>
<div style="text-align:center;">20</div>
<div>SEGT</div>
<div>Unknown</div>
<div style="text-align:center;">14</div>
<div>WNHY</div>
<div>Master Card</div>
<div style="text-align:center;">70</div>
<div>HFIW</div>
<div>Visa</div>
<div style="text-align:center;">12</div>
<div>SHGY</div>
<div>Visa</div>
<div style="text-align:center;">50</div>
<div>EBVG</div>
<div>Unknown</div>
<div style="text-align:center;">11</div>
<div>RUEX</div>
<div>Master Card</div>
<div style="text-align:center;">25</div>
<div>WTGD</div>
<div>Amex</div>
<div style="text-align:center;">35</div>
<div>TGDF</div>
<div>Master Card</div>
<div style="text-align:center;">30</div>
<div>RFHC</div>
<div>Visa</div>
<div style="text-align:center;">20</div>
<p> </p>
<p>In the second table I want to display the total count for each under column 3 i. e </p>
<p> </p>
<div>Detail Col 1</div>
<div style="text-align:center;">Detail Col 2</div>
<div>Total Count</div>
<div style="text-align:center;">Pune</div>
<div>Master Card</div>
<strong>135</strong>
<div>Visa</div>
<strong>102</strong>
<div>Unknown</div>
<strong>25</strong>
Amex
<strong>35</strong>
<p> </p>
<p> </p>
<p>Can anyone suggest the way to achieve this. Till now I have not applied any group on this and tried to keep things as simple as possible.</p>
