Pivot table sum of values

Help
1

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

pivot
pivot960×540 7.26 KB

Regards,
Parvati Thalal

2

hi

can you share the VB code in Invoke activity ?

3

yes sure…

Main.xaml (19.3 KB)

Shared you the xml file.
kindly check

Regards,
Parvati Thalal

4

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

5

I resolved this issue…

6

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