what would be the extra region shows ? like which value it shows?
It won't show any value , it is a dummy entry for further calculations,
like if region ='apac' rthen sales
elseif region''UK' then sales
elsif region ='usa' then sales
else region='extarregion' then prev_sales etc..
You can try doing union at data source level. Below is the syntax for table with three columns.
select COUNTRY,REGION,STATE from Region
select "extarregion" as Country, NULL as REGION,NULL as STATE from Region
I have got it , thanks for your reply.
But i want to add in front end level otherwise
1.it will add 1 lakh nulls
2.other reports we need to filter extra region value.