1 Reply Latest reply: Oct 23, 2015 10:02 AM by Gysbert Wassenaar RSS

    Pivot Structure - display migration

    Sabrina Richter

      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!