How to get Sum of row members in ScoreCard?

Hi,

We have ben working on BSM 2005.

We are not able to get the sum of row members in ScoreCard view.

Say,

I have a KPI as Total sales of various countries and their respective cities.

For example:

Total Sales $6000

India ( )

Delhi $1000

Calcutta $500

Bangalore $1000

USA ( )

New York $1000

California $2000

San Diego $500

(Country is a dimension and not a KPI)

Now in the above case what should we do to get the total amount for each country depending upon it's cities (eg. India should show a total sum of $2500)

We would really appreciate any help in this regard.

Thanks.