Eclipse Community Forums: BIRT » Calculate grand total in crosstab for months range

Home » Archived » 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

Eclipse User

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!

Attachment: sum_problem_crosstab.png
(Size: 10.68KB, Downloaded 351 times)

Re: Calculate grand total in crosstab for months range [message #975337 is a reply to message #974887]

Wed, 07 November 2012 15:05

Eclipse User

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.

Re: Calculate grand total in crosstab for months range [message #981477 is a reply to message #975337]

Mon, 12 November 2012 07:52

Eclipse User

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 01:00

Eclipse User

Great to hear! You're welcome!

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

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 20:53:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter