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

Help

Home

Home » Archived » BIRT » Calculate grand total in crosstab for months range

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

Calculate grand total in crosstab for months range [message #974887]

Wed, 07 November 2012 12:13

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!

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

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 20:05

Michael Williams

Messages: 1925
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

Developer Evangelist, Silanis

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 12:52

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