Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » (no subject)
(no subject) [message #692832] Tue, 05 July 2011 10:25 Go to next message
Nicola is currently offline NicolaFriend
Messages: 184
Registered: July 2009
Senior Member
Hi,
with a cube I show 3 element values aggregate by month and at the right
of the cube I calculate the sum (on the year) and the average:

A jan_value feb_value ..... sum average
B jan_value feb_value ..... sum average
C jan_value feb_value ..... sum average


But for the C element I don't want to have the average calculated.
I saw that aggregation build has a filter condition, but on it I cannot
find the way to exclude the C element (only cube's summary fields are
shown)..
Any suggestions, please?

Thank you
Nicola
(no subject) [message #693035 is a reply to message #692832] Tue, 05 July 2011 16:26 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Do you want to hide it?

If so you could add a crosstab script that checks the cell id (not the
aggregation but the container cell) and then checks the dimension value
and set the display to none. Look at the attached example.

You may also want to read this blogpost:
http://birtworld.blogspot.com/2010/02/birt-crosstab-scripting.html

Jason

On 7/5/2011 6:25 AM, nicola wrote:
> Hi,
> with a cube I show 3 element values aggregate by month and at the right
> of the cube I calculate the sum (on the year) and the average:
>
> A jan_value feb_value ..... sum average
> B jan_value feb_value ..... sum average
> C jan_value feb_value ..... sum average
>
>
> But for the C element I don't want to have the average calculated.
> I saw that aggregation build has a filter condition, but on it I cannot
> find the way to exclude the C element (only cube's summary fields are
> shown)..
> Any suggestions, please?
>
> Thank you
> Nicola
Previous Topic:New To BIRT
Next Topic:Internal bookmark (label to label)
Goto Forum:
  


Current Time: Sun Dec 21 16:07:53 GMT 2014

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

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