calculation in crosstab report

[EArumugam]

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

[PRIT AMRIT]

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?

[EArumugam]

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