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

Help

Home

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

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

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

Wed, 03 October 2012 15:17

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 15: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 15:31

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

Report message to a moderator

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

Wed, 03 October 2012 17:00

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.

Report message to a moderator