Add a total line to a birt chart

Hi every one i am new in the birt world and i have a question.

i have a report with a chart, and i want to show another section with the totals, this total line will show the sum of other lines.

the attacht file is the report.

any idea? thanks.

Find more posts tagged with

Comments

bhanley

Is this total line supposed to be part of the chart or a text-based summation under the chart? I looked at your report, but I do not see where you want to add the summary info.

Alexus

thanks for the help.
I would bring the total line as another line, but that is the sum of all the lines that are listed in the report, as shown in the attach image

Alexus

Any idea? can BIRT do something like that?
Thanks

cjmaloof

You could just manually add an additional Y-series to the chart, whose formula is all the other series added together. (You'd have to remember to update it if you added or removed other series, of course.)

Alexus

thanks for the reply, but, you can guide me how to do this?
thanks anyway.

Alexus

Any idea, example or link where i can find the information?

cjmaloof

Just like adding any other series. Open chart, click "Select Data" tab, click "Value (Y) Series" dropdown, choose "<New Series>". Fill in the formula just below the dropdown.