Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Calculate grand total in crosstab for months range
Calculate grand total in crosstab for months range [message #974887] Wed, 07 November 2012 12:13 Go to next message
bars0 Missing name is currently offline bars0 Missing nameFriend
Messages: 2
Registered: November 2011
Junior Member
Hi all!
Does anybody has suggestion how to calculate grand total sum in crosstab only for month where there are data for realisation. This is relation between plan and realisation.
The problem is that for grand total I need calculate sum only from month 1 to 9.
So now BIRT calculate sum(1-9) and sum(1-12) for realisation /plan and I would like to calculate sum(1-9) / sum(1-9)in grand total.
I attach png file for visualisation.
Any help welcome!
Re: Calculate grand total in crosstab for months range [message #975337 is a reply to message #974887] Wed, 07 November 2012 20:05 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1687
Registered: July 2009
Senior Member

I don't know your data setup or design layout, but you could probably filter the grand total element, for the plan group to not include columns where the actual field is null.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Calculate grand total in crosstab for months range [message #981477 is a reply to message #975337] Mon, 12 November 2012 12:52 Go to previous messageGo to next message
bars0 Missing name is currently offline bars0 Missing nameFriend
Messages: 2
Registered: November 2011
Junior Member
Thank you for the hint.
Each measure has another attribute: month.
So in grand total I added filter: measure[budget:month] = measure[realisation:month].
It works!
Re: Calculate grand total in crosstab for months range [message #982434 is a reply to message #981477] Tue, 13 November 2012 06:00 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1687
Registered: July 2009
Senior Member

Great to hear! You're welcome!

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:[chart] rendering and resolution
Next Topic:Removing specific pages in the reports
Goto Forum:
  


Current Time: Sun Dec 21 05:44:20 GMT 2014

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

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