Eclipse Community Forums: BIRT » Different aggregations on a crosstab

Home » Archived » BIRT » Different aggregations on a crosstab(Perform an aggregation on an aggregate column of a crosstab)

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

Different aggregations on a crosstab [message #1731157]

Tue, 03 May 2016 09:15

Billy Zafack

Messages: 2
Registered: May 2016

Junior Member

Hello. I am currently building a report on birt report designer V 4.5.0.
I have a crosstab having two dimensions(Month and category).
I have an aggregatation total (AVERAGE) on the category dimension and aggregatation total (SUM) on the month dimension.

What I want is to get a global total(aggregation at the bottom-right) which is either the sum of the category aggregation or the average of the month aggregation columns. But all I have succeeded s far is to get the sum(or its average) of the measure aggregating on all dimensions which is far from what I need.

I have attached a picture to portray what I want. Thanks in advance for your help.
index.php/fa/25795/0/

Attachment: PB.png
(Size: 12.57KB, Downloaded 433 times)

Report message to a moderator

Previous Topic:	export to pdf file too slow
Next Topic:	Display format of report page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:50:16 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter