R
raoul
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
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