Cross table !

[#1]

CrossTable([Respondent ID],Response,5)

LOAD RespondentID as [Respondent ID] ,

     Date,

     Category,

     WeekType,

     QID as QuestionID,

     Response

     Resident Cust_Nov_Saving_Two_Wheeler;

am using above script for cross table.

i want convert the data from Response so the above cross table cant work getting error so can u suggests me

Thanks

[alexandros17]

is it CrossTable([Respondent ID],Response,4) ???

[#3]

i tried that one also but getting same error :

Field not found - <RespondentID>

CrossTable(RespondentID,Response,4)

LOAD RespondentID as [Respondent ID],

     Date,

     Category,

     WeekType,

     QID as QuestionID,

     Response

     Resident Cust_Nov_Saving_Two_Wheeler

[alexandros17]

It is right ... [Respondent ID] is the field to use!

[#5]

yes  Respondent ID is the field am using same format in cross table syntax but i can get ans