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.