<p>Hi All,</p>
<p> </p>
<p>I am new to BIRT reporting. I am creating a report. In that report I have a cross tab that is showing count of completed customer requests by number of days for each shop. The column dimensions are number of days divided into <1 day,
days, <7 days, <30 days and more than 30 days. Row dimension is Shop and measure is count of requests completed by each shop in the specific number of days. So count of requests completed in < than 1 day for a particular shop displays in the row for that shop under less than 1 day dimension column. Then total count for each column is aggregated in the last footer row of the cross tab report. Below is sample of how the crosstab looks:</p>
<p>
</p>
<p>| RESPONSE TIME | <1 day |
days | <7 days | <30 days | 30+ days |</p>
<p>
</p>
<p>| SHOP | | | | | |</p>
<p>
</p>
<p>| CONSTRUCTION | 0 | 0 | 1 | 0 | 0 |</p>
<p>
</p>
<p> </p>
<p>| CUSTODIAL | 1 | 0 | 0 | 1 | 0 |</p>
<p>
</p>
<p>| METRO | 2 | 2 | 0 | 0 | 0 |</p>
<p>
</p>
<p>| SOUTH | 0 | 0 | 1 | 0 | 0 |</p>
<p>
</p>
<p>| TOTAL | 3 | 2 | 2 | 1 | 0 |</p>
<p>
</p>
<div> </div>
<div>Now what I also need to show is a row below the last Total row. This new row will display percentage of completed requests for each day out of total completed requests. For example, in the above report, it can be seen that 8 requests were completed so each value would be percentage of 8.</div>
<div> </div>
<div>I haven't been able to figure out so far how to do this. Any help in this regards would be greatly appreciated.</div>
<div> </div>
<div>Thanks</div>
