Add Custom column to crosstab after total?

jmasterx

Here is the layout of my report so far:<br />
<br />
<img src='http://i.stack.imgur.com/NbCMG.png' alt='Posted Image' class='bbc_img' /><br />
<img src='http://i.stack.imgur.com/k5pah.png' alt='Posted Image' class='bbc_img' /><br />
<br />
What I need to add is the AUR column here:<br />
<img src='http://i.stack.imgur.com/CkGsW.png' alt='Posted Image' class='bbc_img' /><br />
<br />
This is a calculated field, actually there is 1 for each corresponding row field of which there are 4 here.<br />
Essentially I need to have totals, which are easy to add, but then I would need my own custom total column to do these agregates.<br />
<br />
Can birt's crosstabs do this and allow me to create a column next to total?<br />
<br />
Thanks

kclark

You could put your cross tab inside of a grid or table and then put the new fields in the rows next to your totals. If your needing to grab the data from the cross tab you would also need to create a scripted data set. <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/28206-multiple-cross-tabs-and-grand-totals/'>Here's a post</a> of something similar I was just helping with. Instead of rows next to his totals he wanted them in a new cross tab, but you should be able to do something similar if you use the grid.