Column group value in crosstab

[sophannaly]

Hi,

I have design my crosstab which is column group by table_type and revision. For example, there are 2 values for table_type. I want to use the first table_type column group value in the second table_type value. I have tried with define variable, when it shows in first table_type column group, then it shows the correct value, but when I shows in second table_type column group it will show as 0. I define that variable with expression like ($F{table_type}==1)?$F{amount}:0.

Can anybody tell me how to use first table_type column group as global value that I can use it in other column group?

Best regards,

Sophanna

[sophannaly]

Could anybody give me idea on this please ? Because I need to make this report in urgent.