Multi Pivoting on single Source data
- by Nev_Rahd
I am trying to mutlipivot source data (as below )
want results as single column (as below)
My query so far is
SELECT *
FROM ( SELECT *
FROM ( SELECT NK,
DC,
VERSION,
GEV
FROM MULTIPIVOT
) SRC PIVOT ( MAX(GEV) FOR DC IN ( [10], [11], [12], [18] ) ) AS PVT
) SRC PIVOT ( MAX([18]) FOR VERSION IN ( [2006], [2007], [2008],[2009] ) )AS PVT
which outputs results as
what is the way to get this as single row?
Thanks