Could variable solve this? and how?

[n1ef5ng1]

Hi all,

I have this report format

Type	Revenue
Country_Departure	888
Country_Arrival	1199
Country	11111

I will need user to select the particular country and it will display the value. Say if the user choose France, it will show Country_Departure and arrival of France

However, the avaliable field I have is Country_Departure and Country_Arrival, I can't possibly ask the user to select both field france in order to show the result

In addtion, I have additional field call Group_Country where it will display out the countries in the world.

This is my Code for Country_Departure

(sum({$<Transit_Container_Class = {'F'},TXIT_Country.Departure= >} Transit_TEU) ))

I am thinking is it possible that if the user choose France, it will stored the value as an variable ,

and on the expression it will read the value of the variable and paste it on TXIT_Country.Departure.

If is possible how is it done, thank you

[n1ef5ng1]

Solved by

(

(sum({$<Transit_Container_Class = {'F'},TXIT_Group_Country.Discharge ={$(=(Group_Country))