Pivot Structure - display migration

[richters]

Hi all,

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!

[Gysbert_Wassenaar]

See attached qvw.