Rows calculatein in script

[#1]

Hi All,

I'm trying to create a calculation in script like this:

Here is my table:

Countries	Sales	Forcast
Canada	40	100
US	45	50
Spain	32	40
CAnada + US	85	150

What I want is to create the last line in the script.

Thanks

[#2]

Michael,

I updated the discussion and add the real table as attachment.

The reason I need to do it in script is : If I have two measures for example Weight and Dollar and I want to the calculation , as far as I know it's not possible.If you take a look at the attached file you will see that I have weight in the report and I did my calculation in expression , like Sales+ Forecast and  it works for just Weight but if I have Dollar in the report as another measure there is no way to do it.

If you have any solution , I would appreciate.

Thanks,

Nima