How to use where condition in piviot query

Question

how to use where condition in piviot query ,

i am trying following but i got error

set @convert = 'select * from (select * from Loandt where lnno=123 ) Repayment

pivot(sum(Amount) for Lndt

in ('+@columns+')) as pivottable'