Add two rows in pivot table & straight table

[Anonymous]

I have to add two different rows of the same column in a pivot table & straight table and put the data in the same row. for eg. below there are two rows china>>india and india>>china and 3rd row represent the sum of the above two row(in red).

corridor	amount
china>>india	100
india>>china	200
china>>india	300

[olivierrobin]

hello

try something like this

tab2:
load rangeminstring(subfield(corridor,'>>',1),subfield(corridor,'>>',2)) as  from,

rangemaxstring(subfield(corridor,'>>',1),subfield(corridor,'>>',2)) as  to,
value
resident Tab;

and sum your data by dimensions from and to

with maybe ltrim and rtrim to remove white spaces

[Anonymous]

Hi anil,

Can u please give me the expressions which you have written. I can see in the column missing expressions.

[olivierrobin]

the expressions are above

i created a new tab tab2 and my graph was made based on this table

from ans to as dimensions

sum(value) as measure