Cyclic Groups

[n1ef5ng1]

Hi all,

I have a pivot table that contain this cyclic group

Country_Arrival

Country_Departure

Region_Arrival

Region_Departure

Country_Arrival and Region_Arrival comes from this table call Market_Classification_Arrival

Country_Departure and Region_Departure comes from this table call Market_Classification_Departure

I am looking to add two more fields inside the cyclic group call Country and Region where Country includes Country_Arrival + Country + Departure and Region consist of Region_Arrival and Region_Departure.

Using Italy as an example

I tried using aggr() method

Aggr(Country_Arrival&'-'&Country_Departure ,Country_Arrival,

Country_Discharge) but it will only show trips from Italy to Italy instead

My desire output for this two new field is to find the total trips between Italy to the rest of the world and rest of the world to Italy, basically if possible just, Column(1) + Column(2) in cyclic group

Any kind soul can help me on this?