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
