<p>Hello.</p>
<p> </p>
<p>I'm trying to figure out the best way to create a Birt report with several groups using the same data field as their source.</p>
<p> </p>
<p>The idea is to count aggregate sums for several field values from DB and organize these values by different age groups (for example: how many customers are there of age 1-6). I'd like to count all the different report values by age groups like 0 years, 1-6 years, 7-14 years of age etc.</p>
<p> </p>
<p>I tried creating several groups for different ages and one tested using several filters inside one group but it seems that using the same data field for several groups isn't that straight forward to accomplish. I've had also difficulties to find the answer from the net..</p>
<p> </p>
<p>I'll attach a sample excel screen shot about the result I'm trying to acchieve.</p>
<p> </p>
<p>Birt version is 4.5.0.</p>
<p> </p>
<p>Thanks in advance, Elja</p>
