Pivot Table - change the value fields orientation

[csillagyitzik]

When I'm creating a Pivot Table and setting the fields orientation and have 2 fields in the data area (look in code snippet below), the output is something like that:

Field 0
"aaa" Sum of Field 1: 500
Sum of field 2: 50
"bbb" Sum of Field 1: 600
Sum of field 2: 55
"ccc" Sum of Field 1: 450
Sum of field 2: 45

I want to be able to change it to this format:
Field 0 Sum of Field 1 Sum of Field 2
"aaa" 500 50
"bbb" 600 55
"ccc" 450 45

how can I do it in vb .net code?

ptTable.PivotFields("Field0").orientation = Excel.XlPivotFieldOrientation.xlRow
ptTable.PivotFields("Field1").orientation = Excel.XlPivotFieldOrientation.xlDataField
ptTable.PivotFields("Field2").orientation = Excel.XlPivotFieldOrientation.xlDataField