Hi,
I have the following table (SQL query):
Name | Amount | Budget
----------------------------------------------
Peter | 3 | 5
Peter | 1 | 5
Mike | 4 | 6
I want to generate a barchart which should look like this:
#
# #
# # # #
# # # #
# # # #
# # # #
Peter Mike
First bar for each "Name" should be the "Budget" for each "Name". This is 5 for Peter and 6 for Mike. Second bar for each "Name" should be the sum of "Amount". This is 4 for Peter and also 4 for Mike.
The default chart in BIRT generates a sum for each bar when I put "Name" to X-Axis. This leads to a Budget of 10 for Peter and 6 for Mike (which is correct in this case because Mike is only in one row). But I only want the sum for "Amount", not for the Budget. Any hints on that?
BR, Peter