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

Using Pivot Table and Correlation:
http://www.savefile.com/files/1578442