Summary Totals as Columns in Cross Tab

Hi,

I have the requirement to be able to add totals as columns in a cross tab, but am having trouble doing this. Is it possible to have the following effect?

Thanks in advance
Giles

Find more posts tagged with

Comments

mwilliams

What is your BIRT version? There are subtotals that can be done that I think would do this, but I'm not sure which version these were introduced in.

glongi

Hi Michael.

i am running BIRT 2.6.2 under Eclipse Helios.

Thanks
Giles

mwilliams

There should be subtotals in 2.6.2. You get totals by clicking on the icon next to a dimension and choosing the totals option. I don't know that the subtotals will look exactly how you're wanting, but you should be able to get those values in your crosstab though. Let me know if you have questions.

glongi

Hi Michael,

Yes, I had already got the totals working just not in the way shown above, so was wondering if there was a way for doing that just to keep the customer happy

, however I will just use the normal totals per group.

Thanks
Giles

mwilliams

This isn't exact, but take a look. It's close. Maybe close enough.

glongi

Hi Michael,

That is pretty nifty. Thanks for your efforts and response.

BTW, is there a good place to see methods I can use on various objects as well as an object list?

Cheers
Giles

mwilliams

You can find the java doc here:

http://www.birt-exchange.com/be/downloads/documentation/#actuate10docs

glongi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="81757" data-time="1314025637" data-date="22 August 2011 - 08:07 AM">
You can find the java doc here: 
 
<a class='bbc_url' href='http://www.birt-exchange.com/be/downloads/documentation/#actuate10docs'>http://www.birt-exchange.com/be/downloads/documentation/#actuate10docs</a> </blockquote>
many thanks

mwilliams

Not a problem. Let us know whenever you have questions!