Adding dynamic row to birt table

ash1203 · 2016-03-04T06:15:37+00:00

Hi, I have a table in Birt Report, DM AM Sales DM_1 AM_1 5 DM_1 AM_1 2 DM_1 AM_1 1 <span…

<p>Hi,</p>
<p> </p>
<p>I have a table in Birt Report,</p>
<p> </p>
<div>DM<span> </span> AM<span> </span> Sales</div>
<div>

</div>
<div>DM_1<span> </span> AM_1<span> </span>   5</div>
<div>DM_1<span> </span> AM_1<span> </span>   2</div>
<div>DM_1<span> </span> AM_1<span> </span>   1</div>
<div><span style="color:#ff0000;">DM_1<span> </span> Total<span> </span> 8</span></div>
<div>DM_1<span> </span> AM_2<span> </span>   1</div>
<div>DM_1<span> </span> AM_2<span> </span>   2</div>
<div>DM_1<span> </span> AM_2<span> </span>   3</div>
<div><span style="color:#ff0000;">DM_1<span> </span> Total<span> </span> 4</span></div>
<div><span style="color:#ff0000;">Total<span> </span> 12</span></div>
<div>DM_2<span> </span>   xyz</div>
<div> </div>
<div>The requirement here is that, whenever AM is getting changed, I have to calculate sum of Sales. Similarily if the value of DM is getting changed, the sum should be done.</div>
<div> </div>
<div>How can I add the total row dynamically.</div>
<div> </div>
<div> </div>
<div>Thanks.</div>

Find more posts tagged with

Comments

pricher

<p>Hi,</p>
<p> </p>
<p>At the table level, you just need to group by DM, then AM. You then create two aggregates, one grouped by DM, the other by AM. The aggregation for AM is placed in the footer of group AM, and the aggregation for DM is placed in the footer of group DM. Using Classic Models, the table layout looks like this:</p>
<p> </p>
<p>

ash1203

<p>Thanks Pricher, thanks a lot. It works.</p>