Home
Designing Analytics Reports
group and aggregate multiple colums
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I already tried to find a solution in the forum, but stuck, since I am new in BIRT.</p>
<p> </p>
<p>I have a DataSet with following information:</p>
<p> </p>
<div>C1 C2<span> </span> C3 <span> </span>C4 <span> </span>C5</div>
<div>A <span> </span>B<span> </span> 100<span> </span> 200 <span> </span>xyz</div>
<div>A<span> </span> B<span> </span> 50<span> </span> 300<span> </span> zyx</div>
<div>A<span> </span> B<span> </span> 10<span> </span> 10<span> </span> yxZ</div>
<div>A<span> </span> C<span> </span> 20<span> </span> 30 <span> </span>hhh</div>
<div>D<span> </span> B<span> </span> 1<span> </span> 22<span> </span> jjj</div>
<div>D<span> </span> B <span> </span>2<span> </span> 88 <span> </span>kkk</div>
<div> </div>
<div>Now I need a sum in columns C3 and C4 if the content of columns C1 and C2 are identical. The Result should be inserted in the table.</div>
<div> </div>
<div>Something like this:</div>
<div> </div>
<div>
<div>C1 C2<span> </span> C3 <span> </span>C4 <span> </span>C5</div>
<div>A <span> </span>B<span> </span> 100<span> </span> 200 <span> </span>xyz</div>
<div>A<span> </span> B<span> </span> 50<span> </span> 300<span> </span> zyx</div>
<div>A<span> </span> B<span> </span> 10<span> </span> 10<span> </span> yxZ</div>
<div><strong>A<span> </span> B<span> </span> 160<span> </span> 510</strong></div>
<div>A<span> </span> C<span> </span> 20<span> </span> 30 <span> </span>hhh</div>
<div><strong>A C 20 30</strong></div>
<div>D<span> </span> B<span> </span> 1<span> </span> 22<span> </span> jjj</div>
<div>D<span> </span> B <span> </span>2<span> </span> 88 <span> </span>kkk</div>
<div><strong>D B 3 110 </strong></div>
<div> </div>
<div>Can anybody please help me to get on track</div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div>Dirk</div>
</div>
<div> </div>
Find more posts tagged with
Comments
There are no comments yet