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 07:13 Go to next message
bars0 Missing name is currently offline bars0 Missing name
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!

Report message to a moderator

Re: Calculate grand total in crosstab for months range [message #975337 is a reply to message #974887] Wed, 07 November 2012 15:05 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 823
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.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Calculate grand total in crosstab for months range [message #981477 is a reply to message #975337] Mon, 12 November 2012 07:52 Go to previous messageGo to next message
bars0 Missing name is currently offline bars0 Missing name
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!

Report message to a moderator

Re: Calculate grand total in crosstab for months range [message #982434 is a reply to message #981477] Tue, 13 November 2012 01:00 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 823
Registered: July 2009
Senior Member
Great to hear! You're welcome!

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Previous Topic:[chart] rendering and resolution
Next Topic:Removing specific pages in the reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 10:25:20 EDT 2013

Powered by FUDForum. Page generated in 0.01724 seconds