Hi all,

I want to add 2 fields(sex,emp_name) into the row field of a pivot table. I'm able to add in a field by using this code:

  WITH THISFORM._PIVOTTABLE
	.cAlias = ALIAS()
	.cDBCName = DBC()
	.cDBCTable = DBF()
	.cpivfldrow = ("sex")   <----------------------here                        
	.lHasColumnTotals = .T.
	.lHasRowTotals = .T.
	=ACOPY(aflds,.aAutoFields)
	=ACOPY(aFList,.aFldList)
	.MakeOutput()
  ENDWITH

But i can't add two fields into the pivot table, it always show error although i can visually in the excel. Can anybody tell me how to solve this?

Thanks.