i want to create a crosstab where in the column i have a lastname on the row a date and on measure a name of a city there is possible?
i want a crostab like this
| pippo | pluto | paperino | |
| 01/11/2013 | topolinia | paperinia | plutinia |
| 02/11/2013 | paperinia | paperinia | topolinia |
the table is
| date | name | city |
| 01/11/2013 | pippo | topolinia |
| 01/11/2013 | pluto | paperinia |
| 01/11/2013 | paperino | plutinia |
| 02/11/2013 | pippo | paperinia |
| 02/11/2013 | pluto | paperinia |
| 02/11/2013 | paperino | topolinia |
tanks
0 Answers:
No answers yet
