Hello, I am using pentaho report designer. I got a problem with it. I need know how to report designer pentaho sum two columns? I tried to do it. Unfortunately it didn’t work. So experts please help me to resolve it. thanks.
Hi Karen,
You can have the sum of two columns in the Pentaho Report Designer by going through the following steps:
a)two SUM functions and
b)one Open Formula function.
SumFunction1=SUM(column1)
SumFunction2=SUM(column2)
SumFunction3=[SumFunction1]+[SumFunction2]
For example,Â
| CLIENTÂ NAME | PRODUCT:A | PRODUCT:B |
| ABC | 10 | 20 |
| XYZ | 30 | 40 |
Total  products for Client 'ABC': 30
Total  products for Client 'XYZ': 70
Total products for all clients: 100
Hello,
The Pentaho Report Designer (PRD) is a desktop application that provides a visual design environment to create report definitions. The report definitions can be executed and saved locally via PRD or published to a Pentaho Bi Server to allow many people to access and schedule report execution. PRD is geared towards experienced and power users, who are familiar with the concepts and data-sources used. You can have two sum function and one formula field. It goes like these:SumFunction1=SUM(field1), SUMFunction2=SUM(field2), SumFuntion3=SumFunction1+SumFunction2
