You are here

Sum by group horizontally

Posted on February 8, 2017 at 6:16am

I got a request and I dont know how to properly start.

To simplify I need to calculate total of ID, NAME based in the rows.
The cell for Total mus be one for every ID even if it has more than one row.

This is a example to what i need to accomplish.

Tabla 1
ID	Name	price	total
10	John	5	10
10	John	3
10	John	2
30	Steve	5	20
30	Steve	15	20

Jaspersoft® Studio

jose97

2

Joined: Feb 8 2017 - 5:45am

Last seen: 4 years 6 months ago

0 Answers:

No answers yet