at the moment I fail preparing a pivot table.
My data model is as followed:
The primary key is the IdentNo. For each IdentNo there are two Versions (=years) available (as rows). I now want to show the migration of the two versions (e.g. IdentNo 5002 has Classification P01A in 2014 and P01B in 2015).
The Privot table should look as follows
Category - Structure - SubCategory - Classification (2014) - Classification 2015 - sum(Always1) - sum(Points)
so that the user is able to analyse which classification of last year migrates in which way.
See attached my example.
Thanks in advance!