Hi,
I have a problem designing a Pivot Table.

Example :
I rent appartments.
Many tenants rent many appartments in many cities.

I would like my Pivot Table to show if there are any tendancies for, say,
those who rent in Paris to also rent in Tokyo.

But I can't get my layout set up right to show this.
Here is the data in CSV :

TenantID;        Appart#;        City;
Toto;               500;         Paris;
Toto;               123;         Paris;
Toto;               1000;        Tokyo;
...
Jojo;                147;        Acapulco;
Jojo;                157;        Nice;
Jojo;                256;        Paris;
...
Andrej;              198;        Smorglst;
Andrej;              199;        Smorglst;
Andrej;              267;        Paris;
Andrej;              789;        Tokyo;
...

Any help appreciated.
Raoul