Not able to use pivot feature when using sql query

[raksha]

select AsOnDate,SUM(OSBalCCY) AMT from Inv_Base_Movmnt_Debentures GROUP BY AsOnDate

Im not able to use pivot table on this query.

[Luiggi]

Please check Creating pivot tables