Pivot table sum of values

Hello All,

As i am creating pivot table with the help of invoke code activity but the sum of all values is coming in row field and i want that sum of all vales comes in column field as shown in below image.

kindly check the below issue

Parvati Thalal


can you share the VB code in Invoke activity ?

yes sure…

Main.xaml (19.3 KB)

Shared you the xml file.
kindly check

Parvati Thalal

can you try to change following to column ?

oPivotField = CType(oPivotTable.PivotFields(“AppcoBranch”), Microsoft.Office.Interop.Excel.PivotField) ‘Specfiy the coulmn name’
oPivotField.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlRowField
oPivotField.LayoutForm = Microsoft.Office.Interop.Excel.XlLayoutFormType.xlTabular
oPivotField.RepeatLabels = True

oPivotField.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlColumnField

I resolved this issue…

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.