Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
group and aggregate multiple colums
knulfturnschuh
<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
pricher
<p>Hi,</p>
<p> </p>
<p>In the table binding, create a group on columns C1 and C2:</p>
<p>
knulfturnschuh
<p>Thanks Pierre,</p>
<p> </p>
<p>that is exactly what I was looking for.</p>
<p> </p>
<p>Thanks for your quick response and support</p>
<p> </p>
<p>Dirk</p>