Adding derived values in grand total column

Hi all,

My cross tab has missing column in grand total! I have a "grouped by" column of two levels.. each of these columns have a value picked from data set and calculated column (derived value).. My report requirement says i need a total column at the end and I added the same.. but the problem is the total value of the columns come up except for my calculated column.

My question is how do i add a column of derived values in my grand total. If i select the expression icon and select "Totals" .. i don't see my derived column. I only see my colums that I picked up from the data set...

Please help

Thanks in advance,
Abdel Olakara

Find more posts tagged with

Comments

mwilliams

Hi Abdel,

Can you set up a sample report with the sample database with this setup, so I can run/edit the report to see what I can figure out? Thanks.

jlspea01

I have the same issue... I have two columns of data:
foo (int) and bar(int)

I have a 3rd column which is derived:
baz (float) which is the result of foo/bar

When I create a subtotal of grand total for the row on my data cube, there are
only totals for foo and bar.

Furthermore, if the option where to be available, the result would need to be:
sum(foo) / sum(bar) to be accurate and not ave(baz).

For now, I can get by without showing the totals, but I will keep my eyes peeled for a solution.

ricardok

Hi!

I think I have a related problem. I need 2 "Grand total" columns in a CrossTable, one for the total and one for the percentage, e.g.:

[value1] | [value2]| [SUM1(value1+value2)] | [percentage(SUM1/GrandTotal)]

Is it possible to add a grand total AND a percentage to SUM1/Grand total?

Thanks - Ricardo

Abdel

Welcome! that else can I say! I am stuck with the same issue.. If anybody get idea how to implement this.. please post it

Thanks,
Abdel Olakara

Rupesh_Mh

can u just tell me the expression ur using 4 deriving col.

mwilliams

Hi jlspea01,

You should be able to drop a data item in the cell that is in the grand total row of your derived column and put something like data["foo"]/data["bar"]. This should give you the correct number for your total foo / total bar.

ricardok

Yes, it works. But the total and the percentage is in one column. Doesn't look so well. When this could be solved, it would be perfect!

Abdel

Adding to ricardok.. apart from that.. I have a total for % also.. this is SUM(data["foo"])/bar where is sum of another column. the bar do not come up in the cross tab but its value is fetched through Data set query.. my question is how do i get the SUM(data["foor"]) even if I add a data item??

Any Idea?

Thanks,
Abdel Olakara

Virgil Dodson

I think I found a solution that may help some of you. The problem I also faced was getting a Grand Total on the bottom of my Custom derived crosstab column. To do this, I first turned on the Totals for my existing columns. This left a blank space under my derived column. I then selected my whole crosstab, and then Binding tab, then Add Aggregration. I created two custom Aggregrations that summed up each of my existing Measures. I had to select ALL for Aggregrate On so it would SUM up the whole column. Once I have done this, then I can add a Data control where I want the TOTAL to be, and then choose my new Aggregration fields in whatever formula I want.

The enclosed example is from BIRT 2.3.2

Migrateduser

Hello everybody,

I know, this post is very old .. but I'd like to know if you found a new solution with new birt, for example the 2.5 version ??

Migrateduser

<blockquote class='ipsBlockquote' data-author="vdodson">I think I found a solution that may help some of you. The problem I also faced was getting a Grand Total on the bottom of my Custom derived crosstab column. To do this, I first turned on the Totals for my existing columns. This left a blank space under my derived column. I then selected my whole crosstab, and then Binding tab, then Add Aggregration. I created two custom Aggregrations that summed up each of my existing Measures. I had to select ALL for Aggregrate On so it would SUM up the whole column. Once I have done this, then I can add a Data control where I want the TOTAL to be, and then choose my new Aggregration fields in whatever formula I want. 
 
The enclosed example is from BIRT 2.3.2</blockquote>
 
Hey ... i don't manage to access to your crosstab_sampme.rptdesign .. 
how can i do it ? 
please ... 
thanks !

Virgil Dodson

Hi Brice,
The example is enclosed in this thread, on my previous post. Just click it and download it.

nimbient

Hi, 
 
I want to create a report similar to the enclosed design , but the orientation of the cross-tab is vertical , and the total should be shown in the column area . Something like the attached image . 
<img src='http://i33.tinypic.com/6fulpy.png' alt='Posted Image' class='bbc_img' /> 
How can I achieve this . Thanks ,

mwilliams

Hi nimbient,

You should be able to handle this with a standard grand total column for the crosstab. The derived column might not get totaled. If not, you'll have to calculate this yourself and add a grid to your grand total column and display your computation in the grid in a dynamic text element or something.

Hope this helps. Let me know if you need further information.