OLE Programming: Hide Excel Pivot Field Subtotals

[Former Member]

Hi, Experts,

I am using OLE to pass data to an Excel file and create pivot table.

I wrote the following to add a row in the pivot table:

  DATA: L_FIELD TYPE OLE2_OBJECT.
  CALL METHOD OF M_TABLE 'PivotFields' = L_FIELD
    EXPORTING #1 = 'Country'.
  SET PROPERTY OF L_FIELD 'Orientation' = 1.
  FREE OBJECT L_FIELD.

However, there is a subtotal for each country in the pivot table, I do not want them.

I know how to do it in Excel, but I cannot do in the ABAP OLE.

Need your advice.

Thanks,

Urchin

[Former Member]

Hi, Experts,

I am using OLE to pass data to an Excel file and create pivot table.

I wrote the following to add a row in the pivot table:

  DATA: L_FIELD TYPE OLE2_OBJECT.
  CALL METHOD OF M_TABLE 'PivotFields' = L_FIELD
    EXPORTING #1 = 'Country'.
  SET PROPERTY OF L_FIELD 'Orientation' = 1.
  FREE OBJECT L_FIELD.

However, there is a subtotal for each country in the pivot table, I do not want them.

I know how to do it in Excel, but I cannot do in the ABAP OLE.

Need your advice.

Thanks,

Urchin

[Former Member]

Done by using the "delete" function on the summarization row