Mahender - 2019-01-18

Encountered " <s_identifier> "unpivot ""
Encountered " <s_identifier> "for "".</s_identifier></s_identifier>

The query we are using is:
SELECT Xaxis, Xaxiscode, Xaxissub, Yaxis
FROM (
SELECT
PLN_FNDATE.MONTHNAME_ENGLISH + ' ' + convert(varchar, PLN_FNDATE.[YEAR]) as XAxis,
convert(varchar, PLN_FNDATE.[MONTH]) + '/' + convert(varchar, PLN_FNDATE.[YEAR]) as XAxisCode,
Convert(Numeric(5,2), SUM(CASE WHEN ORD.STATDAT5 <= ORD.DATGEWGER THEN 1 else 0 END) / Convert(Numeric(9,2),COUNT(ORD.SYSCODE))) * 100 'Hit',
Convert(Numeric(5,2), SUM(CASE WHEN ORD.STATDAT5 > ORD.DATGEWGER THEN 1 else 0 END) / Convert(Numeric(9,2),COUNT(ORD.SYSCODE))) * 100 'Miss'
from ORD
INNER JOIN PLN_FNDATE on CONVERT(DATE, ORD.DATINGAVE) = CONVERT(DATE, PLN_FNDATE.THISDATE)
where year(ORD.DATINGAVE) = year(getdate()) and ORD.STATDAT5 is not null and ORD.DATGEWGER is not null
and (([&SEARCHFIELDS]) and ([&FILTERFIELDS]))
GROUP BY
PLN_FNDATE.[YEAR], PLN_FNDATE.[MONTH], PLN_FNDATE.MONTHNAME_ENGLISH
) ORDERDATA
unpivot
(
Yaxis
for Xaxissub in ([Hit],[Miss])
) PIVOTDATA