Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Sum only on specific bars in a chart
Sum only on specific bars in a chart [message #1782214] Tue, 20 February 2018 13:53
Peter Michaels is currently offline Peter MichaelsFriend
Messages: 1
Registered: February 2018
Junior Member
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
Previous Topic:Possible Memory Leak
Next Topic:Getting 'Data Set script method "Fetch" returned null;' while fetching 2nd Row
Goto Forum:
  


Current Time: Wed Jun 20 04:02:49 GMT 2018

Powered by FUDForum. Page generated in 0.02071 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top