I have a situation here.
I have 2 chars Country and Region.
Region will have some costs associated with them
These costs should roll up to become country cost.
I have to be able to do the following
1> I have to display the country cost on the country line
2> I have to be able to use the individual region cost in my calculations.
I have tried the following
For US country
I have East and North region and they have 1000 and 2000 cost
Country Region regioncost countrycost
USA nothing nothing 3000
nothing East 1000 nothing
nothing North 2000 nothing
Here countrycost is a calculated key figure which adds regioncost of east and north regions.
Also the regioncost and contrycost are used in the calculations of some other columns
Is this possible?
Please help me here.