Eclipse Community Forums: BIRT » How to show Average in Cross Tab?

Home » Archived » BIRT » How to show Average in Cross Tab?

How to show Average in Cross Tab? [message #931838]

Wed, 03 October 2012 11:17

Eclipse User

So I have a cross tab showing employee names in the rows, and months in the columns. It shows the total hours worked by each employee for each month.

Then I have a grand total for each employee and a grand total for each month.

What I'm trying to do is also show an average for each employee and an average for each month but I can't figure out how to do that.

Thanks so much in advance for any help.

[Updated on: Wed, 03 October 2012 11:17] by Moderator

Re: How to show Average in Cross Tab? [message #931853 is a reply to message #931838]

Wed, 03 October 2012 11:31

Eclipse User

Have you tried using a derived measure?
Take a look at these examples:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1545-derived-cube-and-crosstab-measures/
you may also want to look at
http://www.eclipse.org/forums/index.php/m/924405/

Jason

Re: How to show Average in Cross Tab? [message #931929 is a reply to message #931853]

Wed, 03 October 2012 13:00

Eclipse User

I'm still confused. I don't see anywhere to make a derived measure (I'm probably missing something obvious).

I might just calc the averages in SQL and display a second table. It really seems like it would fit naturally with a cross tab though.

Re: How to show Average in Cross Tab? [message #932082 is a reply to message #931929]

Wed, 03 October 2012 16:25

Eclipse User

Click on the measure icon. Look at the attached image.

Jason

Attachment: derived.png
(Size: 25.47KB, Downloaded 768 times)

Previous Topic:	Can we hyperlink different part of single image with different reports??
Next Topic:	Integrated BIRT Report giving OCL errors

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 17:40:10 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter