COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: EArumugam on 27 Apr 2011 12:27:16 AM

Title: calculation in crosstab report
Post by: EArumugam on 27 Apr 2011 12:27:16 AM
Hi all,

please tell me how to achive the calculation in cross tab repport. relational model.

attached the excel.

in that HOW to acheive the calcualtion cell G28 = (G27+G26)+G25
same for G34=(g32+g33)+g25 and for g38.
thanks in advance.

regards,
Eas
Title: Re: calculation in crosstab report
Post by: PRIT AMRIT on 27 Apr 2011 09:45:15 PM
Let me ask a quick question before we get on this?

In your attached excel, whether all the values under 'Column E' is static? I mean the data is unlikely to change?
Title: Re: calculation in crosstab report
Post by: EArumugam on 27 Apr 2011 11:37:26 PM
it will change based on the user selecttion.

it's crosstab report. in column we have Number and name. above expense and rration column.


thanks,
Eas