Eclipse Community Forums: BIRT » Unable to sum two different tables

Home » Archived » BIRT » Unable to sum two different tables(Need to create new data using column of existing tables)

Show: Today's Messages :: Show Polls :: Message Navigator

Unable to sum two different tables [message #1693663]

Mon, 27 April 2015 10:28

surendra ch

Messages: 1
Registered: April 2015

Junior Member

I need to achieve something like summing up values across cross-tab(example excel file attached)

product Unit cost from factory is coming from one table/data set and is a sub-total, landed cost is coming from another table/dataset and is sub-total too. The cost per unit is some of all the values. And it should be per product classified by product family

Could you please help me out with achieving this?

Thanks in advance..

Attachment: SubTotal accross crossTabs.xlsx
(Size: 12.46KB, Downloaded 151 times)

Report message to a moderator

Re: Unable to sum two different tables [message #1694669 is a reply to message #1693663]

Thu, 07 May 2015 02:39

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

You could store values in persistentGlobalVariables named by the crosstab groupings and do your summations at the end recalling them by the crosstab groupings. If you'd like an example, let me know your BIRT version.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	Error :Could not initialize class org.apache.axis.transport.http.AxisServlet
Next Topic:	Video from Actuate: Aggregation Filter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:48:36 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter