Cognos - How to use "Overall - Total" info to other calculation. Help needed :)

[lordzul]

Hello Team
I have problem with use overall calculation in my Cognos. (i have Cognos 10.2)

So what i have and what i need:

I have example table shown below:

Data1_from_db_col1...Data2_from_db_col2..........Calculation_col3
1.......................................2.............................row(value) * row(value)
2.......................................2.............................row(value) * row(value)
3.......................................3.............................row(value) * row(value)
4.......................................4.............................row(value) * row(value)
5.......................................4.............................row(value) * row(value)

For every column I created "Overall - Total" from menu Summarize/Total.

Now i have situation where i Have 3 Overall calculations what i want use for another calculation

1. Total(Data1_from_db_col1)
2. Total(Data2_from_db_col2)
3. Total(Calculation_col3)

I want make calculation : Total(Calculation_col3) / Total(Data2_from_db_col2)

When i want do this i have output what isnt correct. I think problem is with last column because all calculation are created dynamically and Total summary isn't fixed here..

I tried to use different query to assign value from this summary but i see different value like i have "original" summary and i have no idea how to handle it..

Can you help me with this?

If you want picture from real table let me know i will paste here link to screen shoot

Thanks!