Adding sum of two rows before the actual sum

[aftabp]

I have a report that looks like this in reporter studio



It comes out like this in Cognos



The row Commodity minus Rev. shows the sum for Commodoty.
The row Resultat (Result) show the actual sum which is Total Revenue + Commodity minus Rev + Sum a,b,c + Product C
How do i go about creating a case statement that shows: Total(Revenue) - Total(Comodity) in Commodity minus Rev. ?

[Raghuvir]

hi,

how about adding a data item and writing an expression like Total(revenue)-Total(commodity).

then go to the report design page, unlock the report and then cut the expression in front of commodity minus rev, and then add the new data item created there.

hope this should help.

Regards