I am using OLAP to display dimensions. Is there any way to display a new column which will hold the sum of two rows of any BY column. i.e, Suppose I have count of cities of two country say AMERICA and AUSTRALIA.I want a new column as AMAUS (should be computed field) which holds the sum of cities of both country. how to achieve this in...any clue ?

Thks in advance.

quote:

computed field

That is the correct answer.

Hi JG,
The new column AMAUS shoud be computed from the existing fields in the master file.There won't be any entry for the sum of cities of two country in database.It will dynamically calculate the values and display it in new column of the report.
Hope this helps!

Thanks.

Shankar,

You have 2 rows each of which has a count. Now you want a new column in which you have the sum of the 2 counts. So there are a number of questions:
1. How many BYs
2. Does the report have only 2 rows?
3. What does it have to do with OLAP?

Hi Danny-SRL,
The code which i am using to run the OLAP report is as:
TABLE FILE LOCDIM
SUM
CNT.CITY AS 'Number,of,Cities'
BY LOCATION_CATEGORY
BY LOCATION_GROUP
BY AREA
BY REGION
BY DISTRICT
BY EQSP

Now it is showing me count of cities sorted by different BY clauses.Is there any way to have another column which will be generated dynamically which will show me the count of cities of two AREA or REGION or other column in BY clause depending on the dimension values provided by user.
Hope u got the problem.

Thanks.