Adding extra row/column fields to a pivot table excel C#
===

I have created a pivot table and I have added one value to each row, column, without issues:

        Excel.Range Excel_Range;
        Excel_Range = Excel_Worksheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing);
                    Excel_Worksheet.get_Range("A1", Excel_Range).Select();
                Excel.PivotCaches Pivot_Cache = Excel_Application.ActiveWorkbook.PivotCaches();
                int Row = Excel_Range.Row;
                int Column = Excel_Range.Column;
                Excel.PivotCache Pivot_Cache_created = Pivot_Cache.Create(Excel.XlPivotTableSourceType.xlDatabase, "Sheet1" + "!" + "R1C1:" + "R" + Row + "C" + Column, Excel.XlPivotTableVersionList.xlPivotTableVersion12);
                Excel.PivotTable Pivot_Table = Pivot_Cache_created.CreatePivotTable("Sheet2!R3C1", "PivotTable1", Type.Missing, Excel.XlPivotTableVersionList.xlPivotTableVersion12);

                //Select Worksheet

                Excel.Worksheet Excel_CurrentSheet;
                Excel_CurrentSheet = (Excel.Worksheet)Excel_Workbook.Sheets[2];
                Excel_CurrentSheet.Select();

                Pivot_Table.AddFields("RowString", Type.Missing, Type.Missing, Type.Missing);
                Pivot_Table.AddDataField(Pivot_Table.PivotFields("ObjectField"), Type.Missing, Type.Missing);


It works well but I want to two+ rowfields.

I have been trying different ways to change this line in order to get that result:

    Pivot_Table.AddFields("RowString", Type.Missing, Type.Missing, Type.Missing);

But I have not been successful. Any idea?



Thank you