Hello

I am trying to get relative % of fields.
This is the final table structure after all the calculations and join.

TABLE FILE TAB1
SUM
	SALES
ACROSS SALE_DT AS ''
BY REGION AS ''
END

        2015-01  2014-12  2014-01 
West    27       29       26 
North   28       26       24 
South   27       27       25 

1st column (2015-01) will have the value as is but 2nd and 3rd columns should show the percentage.
for example - for West 2014-12 will have this value... ((27/29) - 1)*100
2014-01 will have this value... ((27/26) - 1)*100


I was able to achieve this by calculating values separately for each region in each table request. But this won't work if there are more regions.

Please suggest any efficient way.

Thanks.

This message has been edited. Last edited by: Enigma006,

You can prefice this TABLE FILE request with one which counts the current number of regions, get that to a variable, use that variable in your calculations... Just a thought as I don't see everything that's happening...