Stacked percentage chart

Haris

can somebody help me on this.<br />
<br />
I have a dataset which looks like this<br />
process c1 c2 c3 c4<br />
Sales representatives* 8 1 5 4<br />
Technology and R&D* 17 3 2 1<br />
Tax* 12 3 7 2<br />
Tendering* 18 3 3 1<br />
<br />
i need dataset like the one mentioned below<br />
<br />
process c1 c2 c3 c4<br />
<strong class='bbc'>total 55 10 17 8</strong><br />
Sales representatives* 8 1 5 4<br />
Technology and R&D* 17 3 2 1<br />
Tax* 12 3 7 2<br />
Tendering* 18 3 3 1<br />
<br />
<br />
so that i can insert <strong class='bbc'>process </strong>into the chart in <strong class='bbc'>category (x) axis series</strong> like this row["PROCESS"] to <strong class='bbc'>get one more bar</strong> in my percentage stacked bar chart.<br />
<br />
thanks

mwilliams

If you're using SQL, you could probably create a union dataSet to union the first dataSet above with the query that would return the total line from the second table. You could also get individual dataSets that show both and use BIRT's joint dataSet and computed columns in the joint dataSet to "union" them together.