Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » The grouping of rows and columns aggregation - help needed
The grouping of rows and columns aggregation - help needed [message #1750867] Fri, 30 December 2016 11:00
Krzysztof Przybyl is currently offline Krzysztof PrzybylFriend
Messages: 1
Registered: December 2016
Junior Member
Hi Fellows,

Please help me.
I know that it is probably very simple, but I can't do it from a week.
I have a table of data (12 columns and 2k rows in the attachment):

Example:

Name Surname Target Actual
ADAM SANDERS 2.20 2.00
MICK MOUSE 1.50 1.50
MICK MOUSE 2.50 2.00
LIL KIM 3.30 3.40
ADAM SANDERS 3.40 3.50
ADAM SANDERS 2.70 2.40
LIL KIM 4.30 4.00
MICK MOUSE 1.80 1.60
LIL KIM 2.40 2.20
ADAM SANDERS 3.00 2.90

And I need to do a report as below:

Name Surname Target sum Actual sum
ADAM SANDERS 11.30 10.80
MICK MOUSE 4.30 3.60
LIL KIM 10.00 9.60

- each person appear only once
- the values in the columns Target sum and Actual sum are summed for each person

Thank you for any help.
Kind regards,
Chris
Previous Topic:How to set color for AreaSeries Chart
Next Topic:Adding sub-report aggregate to a report value
Goto Forum:
  


Current Time: Thu Aug 22 18:14:35 GMT 2019

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

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

Back to the top