To create pivot table i use
xlBook.ActiveSheet.PivotTableWizard(Excel.XlPivotTableSourceType.xlDatabase, xlSheet.Range("A1:D" & ukupno))
xlBook.ActiveSheet.PivotTables(1).PivotFields("Poslovna jedinica").Orientation = Excel.XlPivotFieldOrientation.xlRowField...