The grouping of rows and columns aggregation - help needed [message #1750867] |
Fri, 30 December 2016 11:00 |
Krzysztof Przybyl 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
|
|
|
Powered by
FUDForum. Page generated in 0.02993 seconds