Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to show Average in Cross Tab?
How to show Average in Cross Tab? [message #931838] Wed, 03 October 2012 11:17 Go to next message
Birt Unmitigated is currently offline Birt Unmitigated
Messages: 14
Registered: February 2012
Junior Member
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]

Report message to a moderator

Re: How to show Average in Cross Tab? [message #931853 is a reply to message #931838] Wed, 03 October 2012 11:31 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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


Jason Weathersby

BIRT Exchange
Re: How to show Average in Cross Tab? [message #931929 is a reply to message #931853] Wed, 03 October 2012 13:00 Go to previous messageGo to next message
Birt Unmitigated is currently offline Birt Unmitigated
Messages: 14
Registered: February 2012
Junior Member
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 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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

Jason
  • Attachment: derived.png
    (Size: 25.47KB, Downloaded 107 times)


Jason Weathersby

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


Current Time: Mon Apr 21 05:44:46 EDT 2014

Powered by FUDForum. Page generated in 0.02861 seconds