crosstab calculation and display

I have a crosstab report with a total row at the end. There are 4 columns in the detail section and so in the total row there are sum for all these columns.
these are working fine..
Now I want to do a calculation like sum(col1)/sum(col3) and have to display the results in a text/data/label field. As I am new to to Birt, i am requesting for help

1) How can i do the calculation? or how can i access the values in the summary columns and do the calculation?

2) how can i dynamically set the value of text/data/label field with the calculated value?

3) In which event i can do the calculation and set the final value to a display field?

Thanks in advance

Find more posts tagged with

Comments

mwilliams

Hi Shafeeque,

So, you'd just want to do take the sum of the entire column 1 and the sum of the entire column 3 and do the calculation? Then display the calculated value in a report item below the crosstab? Let me know.

Shafeeque

Calculation part is correct, But i want to display it above the crosstab. Below the crosstab is working fine

mwilliams

Shafeeque,

Because of the way a report is rendered, I don't think there's a way to display the computed total above where you compute it in the report.